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 prefer DPS style classses but i will always choose the class with 2 handed swords in fantasy RPGs. i would play mages more often but i generally don't like the 'big glowing colorful ground markers with area of effect elemental damage attacks' genre of magic aesthetic, it comes across as gimmicky/fictitious/unimmersive, magic should be liminal/surreal/terrifying imo. i basically kind of hate the WoW style fantasy/videogame aesthetic and genre of RPG, the only one i really even slightly enjoyed was Guild Wars 2 (because huge playable cat guys with 4 ears and 4 horns and no paid subscription)