What drives a poor reputation for the Rogue class?

[Hael]

Extra attack definitely does not overpower rogues in the slightest. In fact their damage output barely moves that much. The reason is that there is an antisynergy with the usual tactics to pump up their damage numbers. For instance haste attack + ready action and using their reaction to hit sneak attack again with something like warcaster + booming blade. Both components (booming blade and ready attack) conflict somewhat with extra attack.

Extra attack only really adds a lot of dpr if you have a build that emphasizes it, eg PAM/GWM with advantage and extra damage riders (like paladin improved smite+divine smite). The bladesinger multiclass extra attack version on a rogue is better, but its still not a mega damaging build even there.

Regarding the extra pillars that rogues are supposedly good at. The problem is that skillmonkeys tend to be redundant in optimized parties in 5e. You can very much in the aggregate replace them with judicious party choices. Casters also have a great deal of tools to replicate or exceed what they do.

Scouting is a bit of a trap (again at least in the high op versions of games that I play). You are infinitely better suited to send in a druid familiar (or a druid wildshape that can fly away if something goes wrong), or eg to use divination.

And overall, they have the same problem that sorcerors have. Which is that their role is basically completely overshadowed by a better solution (the bard). IF the bard didn’t exist, you could probably push the rogue up a tier or so.