I still play the Sims. I love it.
There aren't really any games that compare to the Sims in terms of customization and game play, but there are plenty that are in the same vein. Obviously, SimCity is good if you like to build. I also tend to like any of the Tycoon games (Roller Coaster Tycoon, Mall Tycoon, etc.). I mainly play on my PC, though, so I won't be able to help with the other consoles.
Hope this helps!