I've seen RPGs that are good and both of both types. I think both can work pretty well. (Similarly both can fail pretty miserably.)
Though I'm pretty strongly in the camp that you play RPGs (and any games) for their gameplay first so whatever.
--
The RPG Duelling League: www.rpgdl.com
An unparalleled source for RPG information and discussion