I actually really enjoyed playing the sword and shield based fighter from dragon age origins.
I mean the abilities were really cool, I loved shield bash so much I almost married it, the pure expression of raw power it shows when your character smashes an enemy right off his feet with his shield. Another time in DA:O when fighting an orge I was treated to this wicked in'game cutscene of my dwarven warrior shield bashing the thing in the face with enough force to send it reeling backwards, and then tackling the creature to the ground and embedding his axe in it's head. That is just Bad Ass.
And sometimes MMOs do it right as well, I made a dwarven sword and shield warrior(noticing a theme?

)and my favorite moment came when me and my buddy (a rogue) were exploring these catacombs a necromancer had set up shop in. We got to the final room, there was probably about 30 zombies and the necromancer was just behind them. I charged forward into the pack and used cleave(hits all enemies in about 180 degree radius) and great cleave (ditto except 270) and drew all the aggro of the zombies and the caster. but just as said necro was about to cast a spell at me, the rogue leaped clear over the battle and landed dagger first(attack while in midair and got crits with both daggers) in the necromancer, and I made short work of the remaining zombies. no other character type would have been able to pull that off, you think a mage or rogue character would be able to not only deal, but take the kind of damage needed to win that scenario? not a hope in hell, if it had been another rogue or a wizard they would have been toast
Basically, I love playing Warriors if they are made right, with cool abilities
EDIT: also, the game also has to have a well made rogue. in DDO for example the rogue class is greatly outclassed in pure damage dealing power, except when he can get behind the enemy and sneak attack. Me and my pre-mentioned fried play up this style to it's fullest. I barge in and start bashing in skulls, why he rolls behind the pack to get off some sick backstabs and/or targeting mages as the need requires. but if the enemy turn and face him, he's all but useless, so he needs me, the warrior to take the heat while he plys his trade from the enemies own shadows