I think the Targa is great.
I would definitely go for that model – despite the increased weight and higher centre of gravity penalties, which will really not be an issue in road use. Anyone who seriously believes that the extra weight of the targa roof will limit their ability to enjoy the car is only kidding themselves.
But: 911s cost too much for what they offer, IMO.
I've been underwhelmed by any I've tried so far (no 997 yet).
My wife says all 911s are ugly and even the newest are still quite clearly "squashed Beetles" (I have to agree that they are still Beetle-ish, but less so than earlier ones. They are still not beautiful /stunning like a Gallardo, etc.).
Most importantly, she refuses to entertain the idea of getting one...
which makes it easier to sell her the idea of the plus points of a cheaper, more practical alternative