RSX seats are very supportive in spirited/aggressive driving, but are a little harder to endure on long trips...when I drove to Virginia from PA I got restless in the seat and had to take more frequent breaks than I desired.
Never sat in S2000 seats so I cannot comment from experience, but they are very similar seats and probably both made by recaro. So I would imagine the same goes for them.
Theres not many sport buckets that offer real support but are also very comfortable on extended sittings.