Mods work with the Steam version, yes.
But the DLCs really aren't worth the money, at all (
Knights of the Nine is, but that's much bigger than the normal DLCs. Mehrunes' Razor is OK. The rest are really just not worth the time it takes to download, much less money). Go with fan-created mods - they're generally much better, and always cheaper.