So I'm building a track ride (non-transport) and I'm trying to increase the excitement and fear. I've added loads of special effects with triggers but they don't seem to have much of an effect. What do I need to do to make these type of rides fun?
Track rides are just like coasters when it comes to what influences their stats. In fact, the game treats them (and even transport rides) as "coasters" if you make work rosters including them. So basically, to amp excitement and fear, you need speed and frequent, rapid changes in direction.
No track ride can be set for more than 15mph and they can't bank more than 5^, let alone loop. So do what you can within those parameters. Max the speed, use frequent harsh zig-zags, and bank all turns 5^ outboard, which makes the zig-zags even more harsh. But hey, you're only doing 15mph so how harsh can it be? Also include as many headchoppers as possible. By doing such things as much as you can, you can get excitement up well over 5. My best so far is 5.9, ALMOST green there. Fear is 3.something, nausea 1.something. I might could break the 6.0 excitement barrier with a bit more effort.
But guess what? A 5.something excitement and a 3.something fear is actually the best possible set of stats for any ride in the game. It's very attractive to all demographics so will always have a long queue, provided the scenery is 100%, and you can charge about 2x the ticket price for such a ride as you can for a massive all-green coaster that costs you 3x as much to build.
Just don't fall into the trap of adding more and more cars. You're limited by the time it takes to offload the previous customers and load the next batch, so adding more cars above that point only hurts excitement and fear because cars at the end of the ride have to wait in line to unload. You only want enough cars so that 1 leaves the station just as the next is arriving, and no cars wait to unload.