Re: 6 spd Coupe or Roadster over 330 hp?
I don't think it's possible unless you increase the displacement. The only company to do that is Startech/Brabus and that'll cost a pretty penny.
I'm thinking the best we can do with the limiteds is SI tune, Catback exhaust, less restrictive intake and you're probably thinking 240 – 250 hp at the crank at the absolute most (and I'm being generous).
The easy way to get 330 hp is a 100 shot nitrous system.