[None of my mods work/do anything]

I always manually install mods, just got to be sure to follow the correct file path and that you have all the required mods like Cyber Engine Tweaks etc that supports it.

[Questions About Modding Cyberpunk vs ....]

Im right there with you, Bethesda did a good job making modding tools like creation kit, one of they main reasons I still play Skyrim and Fallout 4/ New Vegas is because of the amount of content mods avaliable. I am hopeful that they make something like it avaliable for Cyberpunk 2077 in the future, this game has so much potential. Without content modding it will limit the re-playability of the game, Im currently on my 3rd playthrough and will probably take a break after until they release a content based DLC or content mods are released.

[Questions About Modding Cyberpunk vs ....]

I have hopes for the future of modding Cyberpunk, I read on GOG's forum that some of the Dev's were working with the modding community and interested in creating tools to work with red engine. Specifically its the group working on the Wolvenkit.