I'm not saying a Rogue cant be a good fighter because they can, but they aren't the kind of class i'd consider a "super-hero". I just cant imagine a Rogue clearing out dungeons full of powerful undead and daedra every day of the week. They tend to be more cautious. Also since most Rogues tend to love gold, it would make more sense for them to avoid combat whenever possible and just sneak through hard dungeons to get the loot.
Lara Croft?
Prince of Persia?
Dudes from Assassin's Creed?
Batman?
They're all rogue-types. And they kick [censored].
You're mixing "thief" and "rogue". You're right if you were talking about a thief, like aladdin - they're definitely city dwellers and spelunkers.
But a rogue is a stealthy agile combat specialist.
Also, in TES lore, thieves/rogues are capable of a LOT of awesome stuff. Make sure when you talk about what you think certain archetypes "should" be capable of, you're speaking with TES in mind. :homestar: