Definitely overrated.
Yeah, the main emotion I felt over Aeris' death was frustration... I too was using her as a member of my main party.
The most emotional part of the game, to me, was when Red XIII/Nanaki learns the truth about his father. That part made me cry, but I'm a sucker for things...