You can't be more right. Support as a role is actually more fun that top imo but the point is, 80% of viable and meta support champions are borring as fuck (Janna, Alistar, Sona) would also list Braum but at least he isn't one trick horse like the 3 I listed. What do you do as Janna except placing that simple Tornado, point and click shield, point click slow and huge ass aoe healing pushback? Alistar...even less fun, pulverize and press R to survive, as Sona you are just poking and waiting for that ultimate lol. In the other hand look at Nami, Thresh, Tahm, Bard, Zyra, all of them are badass playmakers but everyone simply favors stupid and boring Janna.
Also, the name of the role is SUPPORT...among Mages, Assassins, Tanks, Divers, Fighters, Marksmans, there is a SUPPORT...really? Why isn't it a Playmaker, Pathfinder, Guardian, Keeper or something like that which actually sound way better and way more apealing than Support? Hech you can make it even more fun like for example when you pick Thresh, you should be Keeper/playmaker, Soraka would be Guardian/Healer, Bard would be Healer/Pathfinder, Braum and leona would be Protector/Tank, etc.
For me, there are boring champions like Pantheon who just spamm spears before he turns into a stun bot, Garen who yells Demacia and spinns, all AA based melees like Yi, Trynda Aatrox but at least they do damage and its more fun to play something boring that do damage than playing something boring that uses just 1-2 spells to annoy you like Alistar or Janna (yes whenever I pick Janna I simply forget to use her slow most of the time, I simply dont need her entire kit to be relevant and whenewer my team is fucked up I just press R lol, or Flash R for some "playmaking".