On nexusmods under the game section filter mods by top by all time and you'll get a good head start on where to begin, many mods require baseline core mods like ArchiveXL, Codeware, AMM etc, install these of course as they are required in the background, then the mod you want on top. They are all drag and drop really.
I have mostly car mods, HD Texture Reworked which is 1.1GB of road textures and surfaces etc. And Nova LUT which improves the highlight and colour grades. I also have Night City Alive which adds gang variations and how often they burst off into gang wars around the city as well as access all area mod that allows you to open doors that are usually not accessible in the game by default.