there are a lot of games that you can play cooperatively or competitively on the same screen, but normally they require extra controllers, if you have 2 console controls you can use both on computer and play games in 2 players.
Examples:
Dirt 3
Street Fighter IV -AE
Trine 1-2
Magicka
and there are other but i don't remenber all of them, but certainly in console this is much more easy since there are more games supporting 2 players splitscreen and you normally already have the controllers.