The old Fallout games were awesome turn based games... although Fallout 3 was fun in its own right, it lost its turn based feel to it.
I don't think they make any turn based games anymore. People don't have the attention span for them anymore and want to always look at constantly moving images. The only type of games I can think of that even come close are the Final Fantasy games.
The Civilization games are pretty good turn based games, but somehow I don't think that's what you're looking for.