I think Steam used to overwrite/delete files that it didn't think were supposed to be there, hence the "mods don't work with steam" belief. Now though you can turn off "auto-update" with Steam games, so that shouldn't happen anymore. Then again, it's Steam.
