which movie, in your opinion had a great soundtrack but the movie itself was terrible.

I think it depends on the definition of terrible. The first movie that sprang to mind when I read the question was Maximum Overdrive. A movie that I think most people consider pretty terrible although it's always been a guilty pleasure of mine and I think the AC/DC soundtrack plays a huge part of that.