I would prefer a film with great visuals and sub par story rather than vice versa
And great visuals doesn't necessarily mean lots of things happening on screen, explosions and such.
Visuals should be able to capture a mood. DP Tim Orr is a good example of what I mean.