Master and Commander has to be the ultimate for amazing sound detail
I still chuckle when I think about how my son jumped out of his skin the first time the cannons let loose.
People walking around on the top deck was cool too. I could have sworn there were people walking on my roof!
The Balrog and cave troll stuff from LOTR is pretty good too.