In recent memory it has to be HBK and Rey vs The Miz and Morrison. The fact that The In Crowd went over took that match from great to awesome.
However, there's one slightly unremarkable tag match that has a special place in my heart. The LOD vs The Rockers on Superstars. If memory serves me correctly the ending was Hawk had Shawn up for a powerslam. Marty dropkicked Hawk in the back. Hawk fell forward, and pinned Shawn.
The next time we saw The Rockers....