I'm more of a single player guy myself, so I've always had a preference for games with great single player experiences.
But I have to say that I just love the single player experience that Sonic & Knuckles provides. Greatest game in the world I tell ya.
This generation, my favorite single player experience has to go to Super Mario Galaxy 2. The amount of fun in that game is out of this world (pun!).