The strange thing about Sneak Attack and ranged weapons is that it actually encourages you to shoot arrows at people who are right next to your friends.
...which is insane. In real life, that's how you end up with a lot of dead friends. But there's no penalty for it in 5e, and for the Rogue, it's actually encouraged. I am considering the following additional houserules:
Combat: Making an Attack: Ranged Attacks: Whenever you miss with a ranged attack, re-roll the attack against a random other creature within 5 feet of the intended target, if any. Use the same modifiers for the attack roll and damage roll. (Use this only if the "hitting cover" rule does not apply, DMG 272)
or
Classes: Rogue: Sneak Attack does not work with ranged weapons.
or
Classes: Rogue: Delete the second paragraph of Sneak Attack (the one about "another enemy of the target within 5 feet"). Advantage is the only way of enabling Sneak Attack.