No, it works in the GOG version fine. I use the GOG version.

Are you calling the folder "mod", or "mods"? It should be the latter. And they definitely go in the user data folder, not the program files folders.