*Checks Steam Workshop again*
No, it's still not downloading to the right place. The reason you're able to see your own mod in-game is because it was already in the correct location when you created it. If you try to download any other mod (beside Cow Simulator) it won't show up in-game since Steam downloads it to the wrong location.
