For standard bullets my opinion would be to stick with projectile collision. For strange weapons, think BioShock 2’s spear gun, better physics would be a good idea.
You can always spawn a impacted bullet actor at the point of collision with the wall.
If you shot someone in the chest with a 50 cal, they would only take a small step back.