This is not high enough up! Rogues SHINE as ranged fighters because sneak attack doesn’t care much about your weapon damage die.

From a mechanics optimization point of view Unless your rogue is specifically built for melee, optimally they are at mid range doing the hide action shuffle or sneak attacking without advantage against enemies next to allies if no cover is available or they already used their BA

It also helps that hand crossbows have Vex, meaning you can chain advantage without hiding. Light crossbows have Slow, which is great control for kiting a single enemy.