I'd say it's worth it, but do some modding to get the best out of it.
Mods such as these at the minimum (and their required dependencies):
Full gameplay rebalance https://www.nexusmods.com/cyberpunk2077/mods/3010
Enhanced police https://www.nexusmods.com/cyberpunk2077/mods/1672
Crowds and traffic https://www.nexusmods.com/cyberpunk2077/mods/3176?tab=files
How are these files so tiny and the developers cannot implement them themselves? That's what I'm shocked at when starting to get into these mods last night.
In a way I love the fact how moddable this game can be that it reminds me of the old days of PC gaming.
They've even got a physics mod for female breasts that move more subtly on motion.