As a kid, it was Remmick in Conspiracy. "WE SEEK PEACEFUL COEXISTENCE!" Then the shriek of the mother alien after it bursts from his beheaded carcass. Still, I loved it.
As for psychological stuff, I guess Schisms. Finding out your arm was amputated and re-attached? Creeeeepy. The holodeck scene was very well done.