I saw that interview with Zack Snyder too and I actually loved it. Part of what makes Superman inaccessible for some is they just view him as too-powerful, they seem him as basically omnipotent (which he is obviously not). So while I absolutely HATE kryptonite, I think it's a cheap gimmick way to bring Superman to within "accessible" power-levels, I generally am in favor of depowering Superman just a bit instead.
I loved the scene that showed those Little Bird helicopter miniguns blazing and hitting Superman square in the forehead and his head kind of whiplashing back. That's in contrast to the ridiculously powerful Superman Returns version where bullets literally bounce off his eyes (as cool as that scene was to watch).
So yes, I like that Superman could be knocks down (maybe even a bit shaken-up) by a direct cruise missile strike. Maybe he could be knocked unconscious by a direct rail-gun (like the rail gun in Transformers 2) strike. And yes, I've always thought that a director nuclear blast should be able to kill all of the Justice League members. It kind of gives them context so we can understand their power, and it makes it so that writers are not just in a continual arms race to prove how powerful different characters are in their universe. It's fun to speculate for a minute, but those make for the weakest storylines and are pretty childish.
I'm also glad MoS showed that for Superman to really go ridiculously fast he has to have a more powerful lift-off to reach those speeds. Like he has to tell Lois is step back in order to get the lift off needed to reach the stratosphere so he can then reach the other side of the world asap. In comparison when he's surrounded by all those soldiers at the end of the battle-of-smallville he just lifts off because he doesn't need to gather those same necessary speeds to reach his Smallville home quickly. I just hope this trilogy makes Superman's power levels more consistent throughout. Like I don't want to see him punching bads guys into Mars or something ridiculous like that.
Finally, one of the reasons I actually liked the neck-snapping is because that basically killed the "debate" of whether Superman (and other Kryptonians) are invulnerable. I wish invulnerability was completely written out of most (if not all) comic characters. It's not necessarily the strength that makes these characters unrelated, but the fact that they "can't be hurt." If that's the case then Superman ever engaging in a fight with another invulnerable character would be entirely stupid. At least with Superman being strong enough to snap Zods neck (as opposed to Zod flying through builds and concrete doing it) it showed that Superman is stronger than all these human-made materials, but that kryptonians are not immune to everything. It just takes someone of equal physical strength to kill them.
So basically, down with invulnerability + making him a bit less powerful = more relatable and more possibilities to write strong stories.
Sorry this ended up being so long, this just sort of spewed out.