Wow, two posts in one day. Damn the interesting threads.
Anywho, a couple come to mind, all from my youth.
WM VI, Warrior beating Hogan. My friends and I were all tired of the Hogan schtick. We ended up cheering almost anybody that opposed him. Taker, Perfect, etc. But when Warrior showed up (being a bunch of long haired, headbanging metalheads probably helped), we were hooked. He was the epitome of cool. Then, when he beat Hogan, we damn near tore the house apart. I still remember the adrenaline flowing like a river.
Side note: Had a bet with a guy at school over the match for 10 bucks. I won. I never got my 10 bucks. Hogan's fans were just like him; phony. Ha!
But seriously, Mr. Carpenter, one day at a class reunion, I will finally get my 10 bucks or you had better be prepared to be gorilla press-slammed.
Second one relates to Warrior as well. His return promo in WCW. Seeing him back in a ring again, calling Hogan out on all the crap (kayfabe and otherwise), and just his larger than life presence was amazing. I didn't even care how long it was, I was hung on every word. Plus, that trenchcoat was simply bad ass.
Another one was when Taker initially turned face. Me and my buds were already Taker fans (because he was cool and also was against Hogan) but when Jake "the Snake" was getting ready to clobber the next person to walk through the curtain (which, incidentally, was Miss Elizabeth) and Taker grabbed the chair so he couldn't swing it, I literally blew a gasket (yeah, I know. But the gasket paid very handsomely and I was young. I'm not proud). I was ecstatic that the Undertaker was now a "good guy" and I didn't have to feel like I was going against my own moral code for cheering an evil, supernatural "bad guy". My life was perfect.
I'm sure there were a gazillion more, such as the Bret Hart/Stone Cold "blood from a stone" Survivor Series match, almost getting trampled by Kamala at a live event, Demolition's face turn (told you I was a metal head) and walking around the mall with a Red Rooster mohawk (yeah, I did that. I was a pretty impressionable fella. Plus, I was dared. Sigh) but those three above are ones that seem to stick out in my head moreso than others.