Indiana Jones Adventure has the best queue on property, but you'll go through it whether you have a Fastpass or not, so get a Fastpass to save time. The standby line is held outside the temple (where the main queue starts), so waiting in standby has no advantage.
Roger Rabbit's Car Toon Spin also has a very elaborate queue, second only to Indy. Fastpass will bypass most of it, so if you want to see it all hop in the standby line.
Most DLR rides don't have strongly themed queues - most are at least semi-outdoors with little to look at. Even Radiator Springs Racers' queue is just okay - nothing you would cry about missing if you used Fastpass. Indy and Roger are pretty much it for big, crazy elaborate ones. Don't feel bad about Fastpassing any other rides, you won't miss anything.