1) I highly doubt it, but can you shift between normal drive and "Sport AT" while you're moving?
I think you can do that but im not sure
2) He said that if you shift down moving too fast or wait too long to shift, it will shift for you. What's the point in being able to shift if it occurs about the same time anyway? Do automatic cars really shift so early before the red line that you could get a better acceleration out of this?
its not that they shift so far below red line, its that auto transmissions usually shift at stupid times (my truck wont shift out of second when flooring it until its been at 120 kph for at least 5 seconds, so if you let off the gas it shifts as it thinks your all done accellerating)
3) Is it possible to "drift" in a car with front wheel drive? I feel like your back wheels need to be spinning during the slide for it to work, but I have a friend who begs to differ.
Drifting is all about reducing the friction in the rear wheels through accelleration or ebrake or whatever, and in a front wheel drive, the fulcrum is in a different place on the car due to the front wheels spinning AND steering, therefore its much more difficult to do drifts in a FWD, and you dont have as much control over them, but yes its possible
4) How easy is it to flip a sedan? I.E. How fast would you have to go and take a turn to roll it?
pretty damn fast in most cases, its going to depend on ride height and tire quality. That said, if you hit a ditch, or a bump while sliding sideways with the ebrake or something, theres a good chance your going for a roll so wear a seatbelt!!
5) What exactly is horsepower a measure of and what exactly can you do to an engine to increase it without outright replacing the whole thing? I know some cars have a restrictor plate or something like that which you can modify somehow to allow better acceleration.
horsepower is a physics term measuring work, its not a car term. But to increase horsepower, an engine works by making explosions thru an exact mixture of air and fuel, increase the fuel and air thru bolt on mods, and you will gain more horsepower. Restrictors usually shouldnt be fucked with, but if its just something restricting due to emissions or something, use a racing chip to defeat it in most cases