I also like smaller tools like Mod organizer or the BG3 Mod Manager better than the bloaty Nexus. These smaller tools are also usually on github so i can see exactly what they do / how they work and can contact the developer if i have questions or suggestions.
I like to fiddle with mods myself and Nexus does not let you do that easily.
Steam workshop is fine for many games that don't have too complex mods, so mostly new or changed assets (Cities Skylines for example). Also for games that have an inbuilt mod manager with load order (Rimworld for example).
So what i hope is that Larian put in an internal Modmanager with loadorder etc. Hopefully on launch. Then Steam workshop will be all you need and it's easy to use even for unexperienced players.