Pretty sure DLC for ME is all still handled through the social.bioware.com website or something and you still have to buy it with "Bioware Points". I think you may have to download and install the modules manually, but it's been a while.
So yes it works in steam, but no you don't get it through steam.