Some mods are very small and will barely take up any space. Once you start getting to mods that add items into the game or comprehensive overhauls though, that's when you can expect a hefty amount of storage to be taken up. On their own, no mod should take up that much space on your hard drive, it's when you start downloading 100+ of these things that you can get in trouble, so keep that in mind.