There are many different herbs you can grow indoors with little light (Basil, Parsley, Chives, Mint, Lemongrass, Rosemary are very common herbs that seem to behave and produce in a non-sunlight area.). But, make sure you read up on them to identify all of their specific needs.
If you do ever want to try out other types of herbs that require more sunlight, it is really easy to create a setup that can produce supplimental/artificial lighting. You can pick up most of the stuff at a local hardware store or gardening store at a cheap price.
For magickal purposes, make sure you understand how the herbs will react based upon how you intend to use it. For instance, the mint herb is great as tea treat headaches and upset stomach, but you don't want to burn it as doesn't smell pleasant.
Cunningham's Encyclopedia of Magical Herbs and Wylundt Book of Incense are great resources to start from.