WELCOME ABOARD, both of you!
I can't say anything about Steam one way or the other, because they won't let me download anything (for some reason they thought Utah was outside the United States - maybe they're right).
To answer the last question, yes, most mods will work with a Steam copy. I've read that you should back it up first, just in case.