I hate Space Mountain, but I LOVE EE. It's so much fun. The backwards part is a big part of that fun to me. My daughter and I have ridden this ride about 50ish times and have sat in the front, back, and most of the middle. We think the front is good for people who are a bit unsure about this ride because it feels slower to us in the front. Now, once you go backwards, of course, you lose that advantage for a few seconds. If you want the front, you can request that with one of the loading CMs. They will have you wait for another set of cars but will then let you ride in front.
RnRC is also fun. It does go upside down, but it is so fast it's over before you know it. The entire ride is only about a minute long. The launch is intense, but keep your head firmly pressed back against the seat and you should be fine.
I've only ridden ToT once. At that time, I said I really didn't need to experience it again, but time has caused me to now think maybe it wasn't that bad. I'll try it again in December if I can convince my daughter to ride it with me. So far, I'm the only one in our family to ride it. Riding it alone was a mistake because I was the crazy lady who grabbed the arm of a complete stranger on the first drop. I was mortified that I did that, so my embarrassment plus my "newbie terror" made it a little difficult to enjoy the ride.