I just finished Final Fantasy VII less than a month ago, and I feel that the spoilerific event at the end of Disc 1 had a significantly diminished emotional impact on me because I knew it was gonna happen. I still thought the scene was quite emotional and exceptionally well done, but I'm sure it would have had a bigger impact had I not expected it.
I'm interested, if you were actually using Aerith prior to her death, were you kinda pissed when she kicked the bucket? I avoided using her because I knew ahead of time, but I remember thinking to myself that I would have been pissed because of all of the wasted experience haha.
--
http://24.media.tumblr.com/tumblr_lg5yivuhCH1qfy2kdo1_500.gif