Now that i have a much better sub (DIY 15" coffin) than i used to have (small HTiB sub), i actually have really started enjoying the music in movies much more. The bass is much more authorative now, making its presence felt, but without overwhelming.
For example, in the movie "Stay" there's a point in the 2nd half of the movie (IIRC) where some house / dance track is used as music, and it has strong bass. Not the thumping shaking rumbling kind, but just strong bass tones that you feel as much as you hear them. Very cool.
I watched Walk The Line before i had my new sub, and i can only imagine what that must sound like with a good sub. I'm tempted to rent it again just to experience the sound again