Hi,
I know what you mean--I'm a major chicken w/ RC's, but I love SM! I ride evertime we're in WDW or DL.
I recommend NOT riding in the front, but sit near the back. The ride is in the dark, but when you're in the last seats you can sort of see where the ride is going. I tried the front once...never again! I think the unexpected makes it scary.
There are no major drops, but then again, my dad loves RC's and said SM was SCARY.
Maybe this is a bad comparison, because there's no way to tell the layout of SM, but go see the Big Thunder Mountain Railroad ride, and I think they're similar. It definitely desn't have the Splash Mountain drop, yuck!
Hope this helps!
<Script language='Javascript'>var rndNum = Math.floor(Math.random() * 10000);eval("var CDTDate" + rndNum + " = 'September 9, 2004 7:00:00 AM CST';");document.writeln("<form name='CDTform" + rndNum + "' action='Javascript:void(0);'>");document.writeln('<font size=2 color=black>

Happy Orlandoversary to us!

</font><br>');document.writeln("<input type=text value='' size=40 name='WrittenByJamesMVenglarikII'>");document.writeln("</form>");if (theFunction) theFunction += "var d = new Date();";else var theFunction = "var d = new Date();";theFunction += "var c = new Date('" + eval("CDTDate" + rndNum) + "');";theFunction += "var diff = (c - d)/1000;";theFunction += "var days = Math.floor(diff / 86400);";theFunction += "var rem = diff - (days * 86400);";theFunction += "var hours = Math.floor(rem / 3600);";theFunction += "rem = rem - (hours * 3600);";theFunction += "var minutes = Math.floor(rem / 60);";theFunction += "rem = rem - (minutes * 60);";theFunction += "var seconds = Math.floor(rem);";theFunction += "if ((days < 0) | (hours < 0) | (minutes < 0) | (seconds < 0)) ";theFunction += "var out = 'We\\\'re finally there!!!';";theFunction += "else ";theFunction += "var out = ' ' + days + ' days ' + hours + ' hrs. ' + minutes + ' mins. ' + seconds + ' secs.';";theFunction += "document.forms.CDTform" + rndNum + ".elements.WrittenByJamesMVenglarikII.value = out;";setInterval(theFunction, 1000);</Script>