I haven't played much competitive multiplayer since CS:Source, but I loved being the last man standing. If you die, well, no one can blame you, since they all died too, and if you manage to kill a bunch of them, or win the round, then you're a god. It's a win-win, really.
It's also really fun to be the last man in counterstrike's zombie mod, because everyone else in the game (who've all been turned into zombies) comes after you.