I've played this game so many times and yeah I think Cloud and Aeris were perfect for each other. Not to say that Cloud and Tifa aren't a good match either, just not quite on the same level.

I remember MissH playing this for the first time last year and Aeris was her favourite character. She was devastated when she died. She couldn't concentrate at all during the fight with Jenova-Life, it's lucky Cloud had the Water Ring equipped.