The best support to climb with is the one you know how to play. Of the ones you listed there, most are pretty versatile and able to adapt to both passive and aggressive lanes. Only leo is pigeonholed into aggression and only soraka is pigeonholed into passivity (even though alistar is usually used for the hard engage, he can peelbot really effectively too with his W).
If you want to be able to get fed and carry, playing mage supports is the way to go, but you can achieve about the same degree of effectiveness in a game with traditional supports too. It really just depends on what your team needs.