I used to play Leona, but I don't anymore in SoloQ. Usually, I think good Supports for SoloQ are Supports that either follow-up after someone else initiate (Braum) or react to the enemies and counter-engage (Morgana, Janna, Nami, ...), OR so called "carry Supports" that don't need follow-up damage from their team (Brand, Lux).
Pure Tank Initiators in Support position aren't tanky enough (due to low income) to survive long enough for a disorganized SoloQ team to follow them (whereas a Toplaner with a full lane income can, this one additional item is the difference between your mates following and acing them or you dying alone and being flamed). Moreover, they are especially hard to play from behind, since their main purpose is to create fights, and you don't want to fight when you are behind. But in SoloQ, you can't expect to be ahead more than half the time (unless you're under-Ranked/smurfing), and especially in a Duo lane where you don't know the other guy.
All that being said, my best winrate Support is still Sona, even after the nerfs following her OP mini-rework. Sometimes you just have to find THE champ that best fits your style and taste.