If you're looking to get into Cyberpunk modding here is what I did.
Welcome to Night City is a very popular vanilla+ type mod pack. It's pretty much just QoL and immersion/animation mods. It has a secondary install called Cyberpunk THING which adds some more gameplay mods that tweak combat and add thematic cyberware, and the
stealthrunner mod I talked about. Stealthrunner is incredible.
There's tons of mod packs with different levels of difficulty to setup. Get a Nexus account for a month and download their vortex ap, pick one, follow their instruction and have fun. Welcome to Night City is a great base you can't go wrong with, pretty much every mod pack includes most if not all the mods in it already. It's a true one click install, no extra steps or tweaks really.
Now for gameplay this is more up to you as to what you want so I would suggest researching to find exactly what you're looking for.
Dark Future been talked about and it's great. Makes the game a lot more interesting to play especially if you've already done a bunch of vanilla playthroughs already.
Enemies of Night City complete overhaul of the enemies, mini bosses and boss fights. Really good mod, enemies and bosses have a much wider variety of attacks and will use a lot of moves that player has access to against you. Enemy netrunners use more attacks also, and will even instant kill you so you really feel the pressure when they're trying to hack you.
They Will Remember Another mod that completely changes the game, adds a reputation and disguise system that keeps track of how many kills of certain gangs you have. Gangs will hate you if you kill too many of their people, they'll call for reinforcements at locations when you're identified and even send hit squads after you. It also makes your street cred matter more, at high level of street cred weak enemies can recognize you and flee or surrender.
Cyberware-EX adds more cyberware options, more cyberware slots. There's another mods Immersive Cyberware that looks interesting but I haven't given a try.
Night City Alive makes the gangs and police fight each other, gangs roam around in cars, etc so it's not just everyone coming after you all the time.
Missing Persons Fixer's Hidden Gems adds nearly 200 mini gigs that direct you to various hidden loot locations and easter eggs already in the game that you might have missed otherwise. Cool way to see more stuff the devs put in the game that slipped by you in previous playthroughs.
Another mods that looks very good that I haven't tried yet is
Hardcore22. It tweaks the combat so everyone is less bullet spongy, but also more deadly. Most enemies will die to a single headshot but so will you. I'm also not sure how compatible it is with other mods since it tweaks a lot of enemy and weapon stats.
Graphics mods and the like are a personal preference and hardware dependent and there's tons of them.
HD Rework textures is a popular one to start, but you can do so much with graphics and cosmetics if you want.
One other mod I would say is an auto-include for me is the simple
Immersive First Person. Just makes it so when you're looking down you can see your body. Also
more gore.
