My picks for where to sit:
Thunder Road forwards - back row. Often times there is some VERY good air to be had here. Front has a good view and often has some nice floater air, but I like the back.
Thunder Road backwards - either end of the train. The last row used to be a fave as you got some serious air coming off the turnaround drop, but that seems to have been tamed somewhat. Still, sitting there with nothing behind you watching the track fade away is great.
Hurler - to me, always a front car ride. If the line is long for the front seat, you can get nearly the same airtime in the 2nd row, and sometimes I think it's a bit better back there.
Carolina Cyclone - last car, front row. This is the least rough seat on the train, and in the front row you have more legroom. To me it's pretty smooth back there.
Scooby Doo - back 2 rows can give some serious pops of air. It always amazes me this goes as fast as it does with a what, 40 foot lift hill?
Vortex - either front row or back row. I feel more like I'm flying on the front of Vortex than I do on BORG or Top Gun, at least until I smack my head a few times in the corkscrew. While not as noticeable as Top Gun, the back row feels more intense.
Ricochet - not much choice there, and not much difference in the ride.
Saturator - depends on how wet you want to get. Front of the car gets soaked, back isn't as bad. It's a bit easier to spot targets from the front for your water bomb, but the back is great as you can see them getting hit. Hint: in the back, wait til you see the roof of the arcade behind Wings before trying to bomb the line.
Goldrusher - not much difference.
BORG - this one seems a bit smoother the further to the front you go, and it's smoother on the inside 2 seats than on the outboard seats. Plus, you have no say in where you sit, so just go where they tell you
Drop Zone - the best view, and usually the best freefall sensation is provided in the car you enter from the far-right queue. You can see almost every coaster in the park, and I always get more of a stomach-dropping sensation in this car vs. the other 3.
Last, but certainly not least - the best seat in the house: Back right corner, yellow Shark train, Top Gun. The front has a great view and is a fun ride, but where TG earns it's high ranking with me is that back right corner. Nice whip in all the inversions, with some VERY strong G-forces on the batwing entry and the flat spin.
The red train is also good back there, but usually feels a tad slower. Another good seat is the back-left corner. It's not quite as intense, but that's the best seat for the first drop.
KenB