As far as I know the only playable games with cloud in it are Final Fantasy 7, Tactics, Kingdom Hearts, and Ehrgeiz (I think)

The best would be FF7. I fail to see how any of the other games compare, although tactics could give 7 a run for its money.