For indoor plants, I have a few things that I like:
Diffenbachia (I think I'm misspelling that). They are very good in indoor light, but they are toxic to animals and small children. For that reason alone, I won't keep one in the house (Figaro enjoys snacking on some of my plants...until he see's me go for the garden hose...I won't squirt him, but he's petrified of it).
Cactus - These are VERY hard to kill, require little water, and do very well indoors. Home Depot has some good grafted cactus that are very ornamental. They make excellent dish gardens.
Orchids - While Orchids do need light, Phaleonopsis (again, I'm sure I'm misspelling that) are very hardy indoors, with blooms that will last anywhere from a month to 6 months (I've got two inside right now in VERY low light that have been blooming solid for 3 months). They get watered once to twice a week. The trick with these is to make sure you don't let the roots sit in water. Root rot will kill them. They are also perennials and if you take care of them, they will bloom year after year.
Bromiliads - I've had awesome luck with bromiliad arrangements indoors. They just need their leaves misted once or twice a day. I rotate mine between inside and out (they are very happy in full to partial sun), but I can keep them inside for a few weeks at a time. I know they are readily available here in Florida (as they are considered a tropical plant), but I'm not sure about the rest of the country.
Peace Lillies - Again, they require very little light but they do need attention. Be careful not to overwater them, and make sure you have a good, quick draining soil to keep them in (I almost always repot anything I buy from a nursery, as I never like the quality of the potting medium they use).
Hope that helps.
Pete