Interesting thread. I also do not like the idea of useless guns but tbh it makes sense with zombies. Primarily because they are operated by brains fatally damaged because of recent (or not so) death. While i can see shotgun being capable of exploding zombies' heads, regular 9mm bullet will only (probably) damage one small component..
To be said, though, we need guns to be more usable in a videogame