If you want a tamer experience, sit in the front. If you want to feel like you're going faster and have more thrill, then sit in the back. This goes for nearly every coaster inside Disney and at other theme parks.
The only one that comes to mind where it doesn't matter is Space Mountain. The car length is so short it really doesn't make a difference where you sit.
Coasters like 7dmt, Big Thunder, Expedition Everest..It's like night and day for the front vs the back