You don't need advantage as long as you target something with an ally adjacent to them. Which is a fairly common occurrence. At least, when I played a Rogue (pre-Tasha's), it wasn't often that I couldn't get Sneak Attack.
You can get Archery Style or the ability to ignore cover from a Feat (or a Fighter dip, if allowed- I had Fighter levels personally. Really high AC's were rare enough that I really only needed the +2 to hit when dealing with stuff well beyond my level- and those kinds of foes were large enough that soft cover wasn't really an issue, but of course, this is something that is highly variable.
I definitely would play a ranged Rogue again and not feel the slightest bit of remorse for doing so, lol.
Tashas advante feeding ability xombos with the cantrios same book.
No tashas you're casting a cantrip no advantage and I'm not sure about off hand attack.
Ranged it earth it if you're using XBE feat. You're also splitting damage and can half it using your reactio at some level.
Your hit points are a resource may as well use them along with your hit dice.
This is why I hate ranged rogues if I'm a melee character. If I was a battlemaster I would offer you attacks to join in melee.
If you're hurt bad enough by all means hang back.
But optimally in terms of damage, dame reduction and spreading the love get in there is generally most efficient.
You're actually gimping yourself and the rest of your party. If you're looking at Fighter dip for archery style twf adds dex to off hand.
I've seen a few newbie rogues run around using their mobility achieving sweet FA. One even asked me why he's not doing much damage. I said go melee.
Next round shortbow plink for 1d6+3 damage. Said Rogue had a +2 dagger.
High elf, elven accuracy feat and dex level 4, melee take one of the cantrips not a bad Rogue.