Handguns (and tripods) also largely ignore collisions and do only rudimentary checks to prevent firing through things, thus allowing them to operate without physics. The larger the gun is, the harder it's just to ignore physics.
I can ask for a concept of a gun which could be possible, but I...