Well mines a 2003 on a 52 plate, done 21k miles and I expect to get around 17k when I px it at a Honda dealers.
They are fantastic cars, way more of a car than the BMW or Boxster BUT both of the others are more flattering as the S has no traction control or fancy gadgets to make you think you are driving god.
As CT said ages ago, he can drive his CTR much quicker from A to B than his S because the CTR is much more predictable. I found exactly the same on my CTR test drive.
If you want a true road racer, get an S, if you are more concerned with ease of use then get either of the others.
BTW, I have nothing against either of the others you mentioned it just they are intended for a different audience.
BTW (#2), 9200 rpm is something else!
BTW (#3), make sure its in the dry, muchos worrying in the wet!