Actually, I don't think Cloud's psyche is ever going to recover from this adventure. He's already got some sort of bizarre Freudian complex with Sephiroth that started with childhood. I've never really seen someone obsess over someone like that and still be sane. Of course, Sephiroth's Oedipus Complex isn't much better. I don't think it's possible for Cloud to ever love another woman. And even if he did, he'd probably end up calling said woman Sephiroth in the throes of passion.

Cloud certainly hasn't had a fun time, nossir.

"Oh, Sephi... Tifa!"
"What?"
"Nothing, nothing..."