Speaking as a fellow ride chicken, I will say Dinosaur is a blast and I recommend getting up the courage to ride it. For one thing, anymore the line seems to always be incredibly short. The atmosphere during the ride is fantastic except for total or near total darkness a couple of times. Also, there are no drops, just turns and if you keep your wits about you enough and listen to the audio, the narrator tells you which way your vehicle will be turning and he never lies, so no surprises or sudden falls.
Star Tours, at least the old version, is more of a motion sickness issue and looks like it will remain one. Just remember you can always break the realism of motion simulators by focusing your eyes on something else. I had to do that with Soarin' a couple of times when I was sitting on the end although looking down at people dangling 30 feet below me wasn't much more reassuring.