EverQuest is the only game that I had such an addiction to, that it was interfering with a healthy lifestyle. After 9 or 10 years of hours and hours a day, I had to cut myself off. I still miss the interaction with that world and the people in my guild.
As far as a console video game, the only games that I spent hours and hours looking for things to do after beating the game, just because I didn't want it to end, were Arkham City (Armored Edition) and Skyrim.