What does Steam backup?
Solution 1:
According to this article on the Steam support site:
Important:
Backups for Valve games created with this feature will not include saved games, custom multiplayer maps or configuration files.
So to answer your question, it will not back up your mods. However, the article goes on to describe how you can back up your full installation.