Ultima Online has had the most "Holy ****" on me. First time in the game
a fellow gamer showed me how to tame a bear. I was stunned. Then he proceeded
by killing a deer and making me a pair of leather pants. A little later i was introduced
in a big player run inn and here i almost bust some intestine laughing at the "Drunken
Rhymer" contest that was held later that evening.
This whole experience convinced me that i had stumbled on to the future of gaming
Later i was jumped by a pack of PKs, the ensuing adrenalin rush had me hooked on that game for 6 years.
Other holy **** moments occurred in a lot of other games, here is a small list:
Wing Commander (Graphics)
Ultima Underworld ( The 3D'ish world)
Master of Orion 2 ( the Challenge )
Command & Conquer (Multiplayer)
Doom ( Multiplayer )