Top Thrill Dragster is awesome, having the motor revving, the tire squealing sounds, the bandstand, the lights, and everything else that makes it actually look like a real racetrack. It adds a lot to the ride.
I heard Disaster Transport used to have awesome theming back in the day, but all the effects have since fallen into disrepair and shut off, kind of like Maverick. I'm disappointed, because I actually like the ride, and I think it would have been cool with working sfx.
Bizarro's (S:RoS) audio going UP the lift hill is actually kind of interesting. I just wish it would shut off after you reached the top, because you can't actually hear any of it while you ride. The drop into the tunnel used to be neat, too, but now it has a huge Bizzaro sign over it, which kind of kills it.
Mean Streak has the effect of making you feel like you're going to dislocate a joint or two, but I don't think that was intended.