-facepalm-
Even if you buy Skyrim through retail, it still requires Steam. So everyone has to mod through Steam. Just wait for any mod to come out, and it's
readme will instruct you on how to apply the mod. It'll be east, trust me.
Just look for where your Steam install folder if, the game will be under Steam\steamapps\common\skyrim