I wouldn't necessarily bet on that. TDK's climax is people debating over pushing a button on boats while Batman fights some dogs and a few swat members. As far as climax's go, not the most visually stunning thing we've seen.
I think it all comes down to how well the climax is done. If it is a big budget SFX extravaganza, you really need to pull out the stops to make it look solid. But I will say, even in a film like Avengers, which had great CGI for it's ending battle, after the initial wow-factor of seeing that the first few times wore off, I don't find it all that interesting anymore. I prefer more character driven conflicts for final fights as well.
Rob Roy is a great example of this. The climax of that film is a sword fight. As far as sword fights go, it's not the flashiest sword fight you'll see by any means. However, the build of tension between the two men fighting has been done so well throughout the film that the entire last fight is a master class example of taking dramatic tension and realizing it through physical violence. It's also done in a style that's more realistic and grounded, which adds to the tension and sense of real danger in the scene.