One of my favourite games to play for the console is NBA 2k. I've always been a big fan of basketball and just sports in general.
Commonly referrer to simply as "2k", this game is quite addicting. I enjoy playing the feature called "My career". You create your own player and play through his career from the rookie rising stars game which determines which team you end up with to a possible NBA championship you can win.
You make decisions through the way that affect the fan support you get as well as your team chemistry. You keep adding to your stats along the way, improving your player as you go.
If you like really fun sport simulation games, I highly recommend this. It is one of the few games I can play for hours and hours on end.