I've never stayed up because of a videogame, but I have stayed up playing a video game ... huge diff.

Recent titles that have kept my late night interest:
TetrisDS (NDS)
Ridge Racer 7 (PS3)
Resistance: Fall of Man (PS3)