Thank you all for giving me input on this decision. I thought about going with the Redline 5W-40 but, after a quick call to Honda, I was discouraged from doing so. Therefore I have decided to give the Redline 10W-30 a shot.
I thought a lot about your post RC211V and based on the driving I do in that car I feel that the Redline will offer the best package for my needs. I don't really need a synthetic that can go 25k miles between changes as much as I need something that can handle repeated bursts up to the 9,000 redline. The car is not my daily driver and it's sole purpose is to provide adrenaline hikes and smiles.
batterycar...to answer your question I would suggest to go take one for a test drive. I have personally never owned or driven a car that handles as razor sharp as the S2000. Aside from the minor lack of low end torque, which really isn't felt due to the low weight of the car, there is nothing on this car that I would change. The tight cockpit of a driver's seat that you literally mold in to when you drive makes you feel Schumacheresque. It's quite a nice ride. For 2004 they bumped up the displacement from the traditional 2.0L motor known as the F20C to a 2.2L motor known as the F22C, hence where I get my screen name from. With the added displacement came more low end torque however the redline was of course sacrificed. Now, the car known most for its 9,000 rpm redline has an 8,200 rpm redline. The really strange thing to most of us on the S2000 forum is why America was the only country to get this engine while Japan and Europe continued to use the traditional 2.0L. Anyhow this is more knowledge about the car then you probably were looking for. All in all it is a fantastically built car with driving being it's sole purpose. If you love to drive simply for the joy of it then you will love this car. Go take one for a spin and let us know what you thought.