Corigliano's Etude Fantasy.
A colossal, sweeping, bombastic, gorgeous piece of work.
And as suggested earlier, Prokofiev's 2nd piano concerto. This piece arguably has all of the attributes that you've asked for, and more.
There's also Ravel's Gaspard de la Nuit. Occult enigma, lament, and terror.