I would have to add in the GTA series, those games are very addictive. You can basically do whatever you want in those games, they are very fun to play.
Medieval: TW and CoH: Opposing Fronts. I've spent like literally weeks (total time played) on each, though i eventually got bored of it after i conquered the world twice on the former and beat the computer on hard in the latter.