350Z 6-Speed Trannys come in 2 types for some reason:
Lemons that wear out right away and get replaced under warranty and as long as you dont get a lemon they are super stout ( and support 400+hp).
Since your car is older you dont have a lemon tranny as by now any problems would ahve come up.
There have been somecompliants about noisiness of our manuals trannies and for the most part these describe normal noises.
The350Z has less noise insulation than for example the g35 Coupe in order to save weight as a purer sports car.
You do not need a new transmission, unless you have addtional symptoms.
Fred..
PS: As for looking out for 03's, main issue is so called tire feathering much discussed in earlier threads here:Please read this thread in its entirety not just the first link a pretty complete discussion of tire feathering as experinced by <some> 03's.
zerothread?id=116328