Bret Hart v Rowdy Roddy Piper (WMVIII)
Hogan v Warrior (WMVI)
Hogan v Slaughter (WMVII)
Mr. Perfect v The Texas Tornado Kerry von Erich (Summerslam 90)
Hart v Hart (WMX)
HBK v Benjamin (RAW match)
HBK v Angle (WMXXI)
Sting v Cactus Jack (Take your pick, many good matches)
Demolition v Hart Foundation Two of Three falls (Summerslam 90 I believe)
Savage v Warrior (WMVII)
Royal Rumble 96
Elimination Chamber (Survivor Series 2002)
Mr. Perfect v Rowdy Roddy Piper (Supertape 91) The Match that made me obsessed with wrestling
Goldberg v Hogan (Nitro, looking back the match was only good but that crowd was absolutely exploding throughout the match)
Helms v the Cruiserwieghts (during the final months of WCW Helms carried that company)

That is all I can think of off the top of my head that could captivate a newcomer. Most of these matches were made by tension in the ring and the crowd, perfect in-ring pyschology, and great wrestling/brawls. Hogan v Warrior at WMVI is still the greatest match of all time: the "wresting" was great for two brawlers, the timing was perfect, the chemistry of the two men awesome, and that spectacular crowd overcomes me every time I watch the match. Too bad audiences don't get up and stay up for an entire match anymore.