Car and Driver did a test of max performance tires recently (in conjunction w Tire Rack)...the Goodyears, PS2 and Yoko's all performed well. Contis were mushier but surprisingly good numbers wise.
Here's the url...
http://www.caranddriver.com/article.asp?section_id=4&article_id=10252
They offer a lot of subjective opinion and objective info...I found this very helpful.
I love my ps2s (06 987S) and will likely stick with them as I have had good results with Michelins on my Porsches. Had good experience with n-rated Pirelli Rossos on my 993 too...very quiet with exellent wet and dry grip.
N-ratings definitely make a difference. If you look up the specs by tire on TR's site, you can see that the PS2s (for example) in N-sizes are significantly lighter and designed for lighter loads. They are different designs. I too have used non N tires on my performance cars but, as some commented, there is a risk they don't mate well with your suspension/spring rate, etc.
Definitely never mix tires on the same axle, or even from front to rear. Amazing how many times i see "performance" cars with 2 different brands/tread patterns front to rear. Geez.