It is a bit of a paradox to me - and my opinion certainly isn't the be all and end all of this, so I don't begrudge anyone who has fond memories of it even in defeat. To me, the game is memorable more for the peripheral things - six overtimes, ending after the trains stopped running, players going 65 minutes, walk-ons (and near walk-ons like Haralson) forced into action. But the game itself was kinda bad. The only memorable play of the entire thing didn't count.
The Duke loss in 1990 is torture, but I recognize it for being a pretty good game with big plays and momentum swings and "oh so close" moments. Burrell fouled out right when we seemed like we might win the thing, then Duke had the thing won but Smitty hit a big 3, then Sellers had a life-saving block, then Tate had it in his hands, then the double clutch. I thought in 6OT, the teams kinda stopped playing and went to bear hugs. Our possessions were 30 seconds of guys standing still until AJ shot off a high screen. Their possessions were taking the lane to the basket that we were giving them and trying to shoot over Thabeet and going for rebounds.
Beyond He Who Shall Not Be Named and Hurley, I remember Alaa Abdelnaby torturing us and still know how to spell it without looking it up, and Phil Henderson hitting a dagger, but I'll be damned if I already forgot the white guy's name for Syracuse who hit an important three to tie it at one point.
Granted, the stakes were different, so it would be logical being that close to the Final Four would be more memorable than being that close to the Big East semis.