IMO the 997TT is a better choice than the 996TT for the same reason as F430 > 360. Sweet spot between performance, modernity, reliability and price. But either are tunable to super high HP if that's your bag.
The 996 is also the only 911 generation that I strongly dislike. Shouldn't be a factor to anyone other than me, but bears mentioning