Spider-man is a slow moving dark ride that also has 3D and simulation effects. It is NOT a roller coaster in any sense. There is a "drop" but it is a simulated effect.
Forbidden Journey is similar to Spider-Man in that it is also a slow moving dark ride with simulation effects (no 3D). No drops on that one, and it's not a roller coaster, but it has some quick turns, and you will be flat on your back at a few points. This is also the one that takes you through Hogwarts castle.
Dragon Challenge is a roller coaster. Both dragons have 5 inversions and several drops.
Flight of the Hippogriff is a kiddie coaster. It has no drops, just banked curves and small hills.
As for roller coasters, there is also Hulk, Mummy, and Rockit. All of these have drops. Hulk has 7 inversions, the other two have none.
The only other rides with drops are: Doctor Doom (shot tower), Ripsaw Falls (log flume), Jurassic Park (big boat flume).
Despicable Me and Simpsons Ride are both simulators.