Great choice. They're not the most reliable cars, but most cars that age are going to take some work. My mother had a 2005 G35 automatic. While I didn't like the slush box, the car was a lot of fun to drive. The handling was better than my Mustang GT/CS and the motor makes good power all over the rev range for a V6. Also, the Nissan V6 sounds good to me and I generally dislike the sound of most V6s. Basically a 2+2 350Z.
From what I recall (several years back) the issues with her car were timing chain related and front end suspension components, so keep an eye out for those. Hopefully your car has had those replaced already. Hard to complain for how cheap they are though.