I have played support for the past few months (I think I got thrown Jungle once). Personally, I love it... I don't care that my ADC goes 16/2 and I get none of the credit... or that I go 0/6 keeping as much of my team alive as I can and get blamed for feeding. I don't care that I can't carry the game... I enjoy helping other people carry it for me. I love enabling things!
I don't know about other support players, but what makes Support enjoyable to me is that I can have 100% faith in my laning partner, as well as the rest of my team, that we can win. My Ezreal just miss a skill shot? Bad luck, that guy moved in a way you didn't predict. I just died trying to get my Graves out of a gank I pinged was coming? Sorry, I should have given you more warning! ^_^. My jungle just tried to gank the lane and resulted in the enemy adc getting a triple kill and double buffs? lol, oh well, we'll just have to be careful.
But that's all because Support goes beyond warding and standing invisible in a brush looking intimidating. Anything skill based pulls a LOT from confidence. Yes, I may know that Ezreal's missed q was flung at a creep he was already killing, or that Graves had been pinged by the entire team to run away... or that I had expressed I wished not to be involved in a fight against their bottom lane, given the levels and items of all present... I may know that this player is not as good as my last adc, or maybe my next, but I don't need to tell them that. All I need to say is "You can do it! I believe in you!" Except in much less lame terms. I've seen enough games turned around because the team stopped yelling at each other to know that, as someone who's not going to win this on their own... stopping the fighting and encouraging good plays is sometimes the best support I can give ^_^