For me the first big whoa moment was Chrono Trigger. When Crono sacrifices himself against Lavos for the team, and I really thought he was dead. Didn't expect to be getting him back.