Another personal favourite among Respighi works is the suite he drew from his ballet Belkis, Queen of Sheba - big, 'hollywood' score which requires huge orchestral forces.
I call your
Belkis and raise
Three Church Windows!
GW, you may also enjoy the Strauss tone poems. They are generally big and good, with all sorts of interesting things going on. In particular, look up
Eine Alpinesinfonie ,
Also Sprach Zarathustra, and
Ein Heldeleben (the others are almost tasteful in comparison)
If you fancy brass players worshiping pagan gods - and who doesn't - try Walton's
Belshazzar's Feast.
And for completely over-the-topness, try Schönberg's
Gurrelieder.
NB