Most likely he/she is unziping the whole thing and not just copying the mod into this mod folder.
Edit: Either that or he is doing it in a way that there is a version number there for him/her.
well I downloaded it into the Mods Folder and Extracted it there, So you had it right the first time, It was also on a new computer so there was no prior SFCRevamp folder so I was just trying to be lazy. Also in the second line you did the first he, all the others are he/she, but it is also correct I am indeed a he.
When you unzip/extract the mod you will have a folder named 'SfCRevamp_vXYZ'. Inside that folder is a folder named 'mods'. Copy and paste mods folder into %appdata%/Roaming/Strive for Power 2. This makes the path for the mod '%appdata%/Roaming/Strive for Power 2/mods/ScCRevamp'
If you extract ScCRevamp_vXYZ into the 'mods' folder then the path would be '%appdata%/Roaming/Strive for Power 2/mods/SfCRevamp_vXYZ/mods/ScCRevamp' which would be incorrect and would cause issues.