The back of any coaster is generally more thrilling since the train is generally accelerating out of the downslope of the hill and the back hasn’t made it over yet. This gives the perspective of more speed in the back, or at the very least, more actual airtime. Hence thrill seekers prefer it.
The front of any coaster generally has better views, but also more wind. The front also hits the turns and hills harder and with more force which can also be more thrilling in its own right. Space Mountain is a good example. You hit those turns hard and with no clue it’s coming up.
With that said, I agree with most. The back. As someone pointed out, I like the back of EE for coming out of the tunnel after the Yeti scene. I like it dark in there and want the train accelerating as I come out that tunnel. Some may like the front for the broken track which is fun.
For mine train and probably SDD, it really doesn’t matter. The rides are too slow to matter.
For RRC, treat it like space since there aren’t any hills with airtime.
BTMRR - back because I’m a thrill seeker.
Any six flags, Busch, Cedar coaster - back. Always.
Source: have ridden over 300 unique coasters.