Ok, strictly on ff7 (not AC or any other part of the compilation). Although originally, as they didn't have Tifa in the game, Cloud was meant to be with Aeris. However, once they decided to kill off Aeris and create this new character, Tifa (who is quite similar to Aeris in many ways), I believe that Cloud and Tifa were then meant to be together. In an interview, Tetsuya Nomura (is that his name? I forgot) stated that Tifa would be someone he'd be attracted to, both physically and emotionally. And, because he put a little bit of himself in Cloud, that's who Cloud is meant to be with. Also, that night under the Highwind... can't deny the chemistry there!
But, because in ff7 you can choose your romantic interest (or, if you're not into romance, you can always "date" Barret), there is no clear answer. I believe that the creators wanted Cloud and Tifa to be together.