Having "literally millions of weapons" looks good on paper, but it makes for non-engaging gameplay if done incorrectly, which it was in the numbered sequels, in my opinion.
overall, borderlands 2 and 3 felt like a chore to play, "get one hour of grinding in", regardless of how pretty it was or interesting the other mechanics were.
And you know what the main difference was between 1 and 2 & 3? Paid loot boxes / real money transactions.
Mass effect was also a RPG, but had much much better combat.
Combat in the witcher 3 was pretty good.
It does, because a common running theme in RPGs is that you get stronger as the game progresses, and in Cyberpunk, by the middle of the game every character build (melee, stealth, guns) easily dismantles enemies. It is only early-game where the enemies seem difficult because your character hasn't had their skill-trees built up yet.
The simplistic AI behavior makes stealth unengaging, the hacking feels really disappointing (why don't cameras or turrets get harder to hack?), the cover system is worse than Mass Effect, and gunplay is middling at best—better than Fallout: NV, but worse than Fallout 4 or Destiny.
Notice how I only compared it with other action/shooter RPGs? Clearly RPG progression isn't my issue with it.