Top mods

I'm personally not playing with any mods (yet) except cyber engine tweaks, but here is a list of mods i think look very impressive

Cyber Engine Tweaks

Metro rE3worked

Stealthrunner

Deceptious Quest Core

New Quest - Encore

Night City Interactions

New Quest - One More Light

Appearance Menu Mod

Wilson's Range

Panam Romance Enhanced

Judy Romance Enhanced

River Romance Enhanced

Immersive Rippers

New Quest - Californication

Immersive Bartenders

Immersive Vik

Immersive Timeskip

Immersive Food Vendors

Immersive City

Immersive First Person

Enemies of Night City

Unlocked - Half Year Montage

Unlocked - Zen Locations

Virtual Atelier

Native Vehicle Customizer

Small things, subtle changes and quality of life improvements:

Stand Still Please

Mute the Sound

No Double Tap Dodge While Crouched

Talk to Me

Silent Silencers and Throwing Knives

-Ambient NPC's

-More Fluid Parkour

-Mark to Sell

-Improved Slide

-Crafting Quality of Life

-Custom Quickslots

-Always First Equip

-Average Hackers + AI Netrunners Enhanced

-Hide Read Shards

-Untrack Quest by Right Click

-Stop Spam

-Stash Filters

-Real Vendor Names

-Quickhack Hotkeys

-Purify the UI

-No Intro Videos

-Muted Markers

-Limited HUD

-Clear Skill Checks

-Shard Codex Collapsed

-Smoother Vehicles

-Ragdoll Physics Overhaul

-Dirt Begone

-Blur Begone

-More Blood Splatters

-Modern Screens

None of these are dramatic on their own- no flying cars, virtual ateliers or full metro systems, but they tidy up a lot of the annoyances of the game and make the UI/UX a lot more immersive.