Through my years of mmo and rpg gaming I've tended to swing between the two extremes of the warrior/wizard dynamic.
Some days I just want to be a dumb tank in full armor soaking up hits and acting as a wall for squishier classes. But then there's days where I love being a glass cannon that can kill something in 1-2 nukes but a strong breeze can kill me.
The least fun I've head with a class was as a healer druid in Everquest. Something so stressful about the party relying on you for heals and if you wipe it's generally your fault. idk how people dedicate themselves to a class like that.
I've enjoyed playing high damage character of several varieties (I used to play a good amount of black mage, red mage and monk in FFXIV) but I have more fun playing tanks (I also find it more stressful unfortunately).
In single player games I tend toward melee classes, I find that if I'm playing a ranged class with enemies chasing me down I feel stressed.
In a current D&D game I'm playing a support focused cleric/sorcerer. I get very obsessive about stuff and have trouble not optimizing. I thought it would be very annoying if someone played a warrior with mighty thews and my warrior with mighty thews was just twice as good as killing guys with a sword than theirs, but nobody is mad at the mage who just makes them better at everything they were already going to do, plus I tend to play my character pretty cheerleadery anyways.