Ruin Explorer
Legend
This is literally the same thing twice.1) sneaking into a base
2) scouting
Gonna be objectively worse at that than a lot of other characters unless they're built quite unusually, and the best methods involve leverage which is likely to avoid checks entirely in most groups.3) persuading a person to give you info
Thanks to their lack of OA protection, they're not actually very good at this. Also, in 34 years of D&D I have never seen that happen, not even once - nor ever heard of anyone describing such. So that's beyond a corner case - even if it's happened in your game, it's basically a 1 in 1000 event.4) race ahead of monsters and grab the mcguffin
Also they're not even close to the best at it. Monks are far better. Casters who have a few L2+ slots to spare and Misty Step and other spells are better too.
That's the same thing again.5) get to a location before the enemy does.
Sure, Rogues are likely to be the best at this one thing - their speciality.6) get past the trapped locked door.
This is basically 4 & 5 again, and all the same applies there. If you're trying to say the DM will have designed an encounter so only someone with Sleight of Hand is allowed to disable the device, well the DM was obviously trying to help the Rogue out, but that won't even be found out until some PC gets there - which may well not be the Rogue. I've seen real-game situations like this - in 100% of cases the intention was that damaging attacks were used to disable the device, not some kind of check.7) disable the device that’s buffing the BBEG
Not really no.8) long ranged combat
This strongly suggests you are being theoretical and haven't thought this through. In current 5E it's objectively wrong. Sneak Attack only applies to 30ft out. In 2024, it might theoretically become quasi-true (assuming they don't change the rules again), but remember it only applies out to the short range of the weapon, because you get Disadvantage beyond that, and cannot Sneak Attack when you have Disadvantage (even if you also have Advantage, it just cancels both), so your single attack will be weak than those of other characters with multiple attacks.
So that means 80ft with a shortbow, and 150ft with a longbow, but Rogues aren't normally proficient in the latter, so 80ft, which is hardly "long ranged combat" in any genuine sense. A DEX Fighter or Ranger with a longbow (which they are proficient with) and multiple attacks is dangerous out to 600ft, albeit with disadvantage beyond 150ft.
So what we've actually got is:
1) Stealth.
2) Moving quickly in combat so long as there aren't OAs.
3) Sleight of Hand.
That's a very narrow range of things to be good at. This is my point. Are they better at Stealth and Sleight of Hand than virtually everyone by say, level 7? Yes! But that's a narrow and specialized realm, not a flexible one.