If you've had any sort of experience like mine with NWN EE and Workshop, then you may have encountered a weird little thing where you'll download the files of your choice only to find that they werent applied in-game. These sorts of things include:

-Downloading modules that don't even show up as available ingame
-Downloading overrides that arent applied
-etc

At some point, Steam, NWN, or Workshop got very confused and, instead of downloading to the game's directory, instead downloaded them elsewhere in the Steam directory. So if you're wondering where your file downloads went, that's where.

To fix this, go to the Steam directory and search for the "Steamapps" folder. From there, go to the Workshop folder, then to the Content folder. Your NWN workshop files should be in there.

TL;DR - steamapps > workshop > content > whatever file you were looking for

After you find your desired file(s), you will need to copy/paste all of the download files into the respective files in the NWN directory > data (so your .hak files will have to go in the hk folder, your .tlk files will have to go into the tlk folder, etc.). The game should apply the necessary changes to the game and whatever content you downloaded should be playable afterword.

Hope that helps, if anyone else has scoured Google in search of answers with no luck.