A single tune that comes to mind for me is "Lost For Words" from Floyd's Division Bell album. It's full range, dynamic, includes SFX ... another Floyd example being "Yet Another Movie" from A Momentary Lapse Of Reason
For a live recording it's hard to beat Harry Chapin's "30,000 Pounds of Bananas"
From further back, I think "Take A Pebble" and especially "Lucky Man" from ELP's first album are pretty outstanding examples. I've used "Lucky Man" to test speaker systems for ages.
There are tons really. I could build quite a list from my full listening history.