Rule #1: Never buy a car as an investment. Assume that it will lose value and if it doesn't, you got lucky.
With that being said, 996's are great cars but I'd buy a 996 GT-3 before the Turbo. Accelerating quickly is fun ... for about 10 mins, then I'm bored. But the GT-3 is fun in every corner.