Note: Unless you've done some serious modifications to your Z, you can run OEM tires.
When the 2002 came out, I did some speed testing at low altitude. At 175 mph, it hits the rev limiter in 5th, and when you grab six, it slows to 162.
It will take a gearing change and about 510rwhp at high altitude to go past 200mph, based on C6 Z06 numbers.
Sidebar: From personal experience racing in the rain (low traction), the best (Y) rated tires for your car are probably Michelin Pilot Sport PS2's, Go 275/40-17 + 295/35-18 on factory rims.