Yes. Didnt unzip, did everything like described. I moved the files to a newly created folder and some of the mods now working, but theres still some with the same issue.
Have you tried uninstalling and reinstalling the game? The mods on my Google Drive Folder are never tampered with or modified inside the file. If the mod is showing in red like that, it's less likely there is something wrong with the mod, but something is wrong with your game instead.