(Psi)SeveredHead
Adventurer
Dwarves are only good at being fighters and clerics? What's wrong with dwarven wizards, rangers, barbarians, rogues, and monks?
Dwarven wizards aren't actually that bad (no real penalties), but rangers, barbarians, rogues and monks all need speed, which dwarves don't have. This is especially a big deal for rogues, who need mobility but have nothing to enhance it (beyond Tumble, which forces you to move at half speed, and dwarves are slow as it is).
A bonus to Constitution is good for pretty much everybody, while Charisma is D&D's traditional dump stat. Plus you get darkvision and a grab bag of random bonuses (+2 to save vs. spells is nothing to sneeze at!). The slow movement is a minor-to-moderate nuisance.
+2 to save is pretty sweet, but that's good for every class. Contrast with speed, which affects some classes hardly at all (fighters, for instance) but affects some classes quite a bit.
All that said, halflings make better rogues and gnomes make better wizards. But dwarven rogues and wizards are still good.
I'm going to have to say "no" to dwarven rogues being "good". You can optimize one, of course, but I can't just see one outperforming a human.