If you have the creator DLC loaded you can hear the gun shots of other people who have the DLC loaded however you cannot hear the gunshots of those who do not have it loaded and vice versa.
This includes modded and vanilla weapons.. you can't hear any of them.