Which character is best for the healer role, other than Aeris?

Have a look at this thread comparing stats of the characters:

^{image from above forum post}

Note that the difference in stats is really pretty minor, and by equipping materia to any character you'll see more variation in stats than you will between characters, if I recall correctly. Additionally the Materia system allows much more versatility than just making someone a "healer", you don't have healers so much as "people with Cure and Revive", so it's easy to slip healing into any team.

Aside from their limit breaks, all characters are basically blank slates when it comes to their role in battle. Note that while cloud is the second best at magic...he's also definitely the best overall and is easily suited to any role. Basically pick a team of three favorite characters based on their personality/looks/limit breaks/weapons/whatever you please, then assign roles as you see fit. Since Cloud is basically a given and too overpowered to dedicate for healing, my healer was always just "Not Cloud" or occasionally "Not Cloud #2", though I usually gave multiple, or all, characters Cure.

Vincent

If you exclude Aeris and Cloud, Vincent has the best (or tied for best) stats in Magic and MP, so he works well as a heavy magic user and healer.

The next highest in those two categories is Cait Sith.

Having said that, with the right materia like Magic Plus and MP Plus, you can make any character into a great healer.