I can't force you to like the role, but I do have a few quips.
If you're not playing Leona/Thresh/Taric/Sometimes Lulu not being tanky is pretty much the norm for supports. However, the tools they bring to teamfights make it so that they don't NEED to be tanky. Sona, for example has a devastating ultimate combined with stat boosts all around.
Same way a healer/clearic in any other game works for the squad. Doesn't mean that their impact can't be influential. Nor does it mean that they can't carry.
Supports who end up climbing are those who know just how much control to take every game. If anything, your team relies on you.
It can be a little annoying to have to deal with vision, especially when you're actively warding like you should, but for the most part, all it takes is asking people to pick up a ward or two, or even just upgrade their trinket and place it. Support is the role of the people, communication is key.
#can'thelpyouthere
Perhaps in the hell known as Bronze. But for the most part, I've been treated like the star player of the team when I support. If someone has an issue with me, it's typically because they got a case of the ass when I asked them to ward/respond to pings.
Consider yourselves Zenith Bladed.