No Clint Mansell with his Requiem for a Dream and the Fountain scores?
His work really impacts on scenes in both of the films.
Yes!
His work on all of Aronofsky's films (Pi, Requiem for a Dream, The Fountain) turned those films into something special.
Pi is just quirky, face-paced and reflects the madness fantastically, whereas The Fountain has that slow, deep thought provoking essence.
*** SPOILER ***
As the music kicks in during The Fountain as the Tree of Life finally dies, combined with the stunning visuals -- the film takes on an entirely new persona. For the entire movie you wait and wait for the music to climax, slowly hearing it build only for it to explode at once in timing with the visual effects. It works incredibly well in my opinion.
*** /SPOILER ***
I wouldn't say The Fountain or Pi are bad films in their own merit though. It's just, from a great concept, story, and narrative; they're given character, life and rhythm which carry you throughout. Where in Requiem the music is brilliant, I didn't feel it adding to the film on the same level that Aronofsky's other work has. In fact, I'm now listening to Clint Mansell as I type this!
Anyway, I've always loved the work of Hans Zimmer in Black Hawk Down and Gladiator. His music really does transform the films for me. The conclusion of Gladiator where Maximus enters Elysium is one of my favourite scenes of any movie and never fails to give me goosebumps, and the raw feel to Black Hawk Down is very humbling.
I've always loved the ending to Meet Joe Black too where Isreal Kamakawiwo'ole's Somewhere Over the Rainbow begins to play. It's jusy beautiful and well worth watching the film to reward yourself with.
Finally, I thought the music of The Shins and Eddie Vedder really worked for Garden State and Into the Wild respectively.
EDIT:
Ah, before I forget too -- the soundtrack for Juno is one of the best I've heard in a while. I just love how melancholic and bohemian it feels.
The Fountain (Ending)
Juno (Ending)
Garden State (The Shins - New Slang)
Gladiator (Ending) (Lisa Gerrard & Hans Zimmer - Now We Are Free)
Black Hawk Down (Theme Song),
Black Hawk Down (Joe Strummer - Minstrel Boy)
Into the Wild (Eddie Vedder - Cold Hard Sun)
Pi
Transformers (Old Movie)