Yeah, indoors its pretty tough for most plants. But there are lots of greens and herbs that will do well in pots that you could move around for the best light.
Discussion
The best luck I've had was using my Aerogarden hydroponic device given that it doesn't need to worry about sunlight. We've got a few houseplants hanging on as close as possible to the south facing windows for the bits of light they can get through the trees but none of them look particularly vibrant.