Maybe that's because I was expecting something like a classic DnD dexfighter/dualwielder type but it just doesn't work that way in DA... In other words it could just be me.
I'd say the opposite. Fighters are pretty lame, because after you decided which weapon style you use, there is no real decision which skills you get. Only for specs and even those decisions are not hard. You get all skills eventually. The only difference is how much you put in dex, str con and in which order you take the skills. This is why rogues are great as you can specialize better.
If you want a D&D'ish dualwielder choose the warrior class and put everything in Dex and strength. It's pretty strong, has good tanking abilities thanks to the high dex and does a lot of damage with berserker mode turned on. A lot more than twohanders. Played a dw warrior on my first playthrough and never had major problems on hard. Except for Sir Cauthrien.
Rogues play different than in NWN and the likes as it you never fight from the front, you have to backstab always. Every normal attack is a waste. And you have to push cunning, dex isn't so much important as in D&D, because of the aggro and flanking. Flanking gives you +20 attack as a rogue, so even if you have low dex and strength, you will hit.
Attack speed is also different than in D&D. In DA it depends only on the weapons. In D&D a strenght or a dex fighter would always have more attacks than a rogue.
And if you have a good tank with threatening, you should not bother with your defense, if everything plays out as it should be, you will not be attacked often. You kill from behind to support your warrio or to eliminate tose that you mage stunned. And warriors do less damage than a good backstabbing rogue. Especially with runes on your daggers.
Stealth is pretty good to, as you get an autocrit if you attack from stealth. Especially for archers this is great, as you can get every 10 seconds a autocrit with combat stealth for just 5 stamina cost. The archery talent which does an autocrit uses 40 stamina instead and has the same cooldown time as stealth. Rogues are pretty strong if played right.
If Orzammar right now is to hard, do the forrest, redcliffe or the circle first. You could also kick Leliana out and come back with her after you cleared the level. If you have the hotfix already installed, remove it, it makes the game harder and you just get a minor damage bonus if you lack cunning. I'd also would respec one of your rogues, as having 2 bards doesn't make sense.
Are you sure that you don't need to have the max tier in lockpicking and can just compensate that with your cunning bonus?
Yes. Raised my cunning from 29 to 30, after that I could open a chest I couldn't open before. I guess it works like this.
Can not open if:
Chest difficutly>Lockpicking x10 +(Cunning -10)
So you could open a level 40 chest with lockpicking 1 and 40 cunning. Or with cunning 10 and lockpicking 4. There are chest you can't open with lockpicking 4 if you do not have enough cunning. Coercion seems to work similar.