Joe, how about a spider plant, there are tiny curley ones that are slow growers and really cute. That would be great for a table in your bedroom near the window. You could also use peace lillies, small of course that would be good inside, not on the window sill so it gets light, you do not need sunshine for either of those. Both are good for helping with cleansing the air.
On your kitchern window sill, if you want to, you could put some herbs that you use in a long thin container and keep them all in one pot.
There are also some cute little ferns and philodendrun which you can keep cut back if it gets too viney for you. There is also a little viney plant called wondering jew that is redish and is nice if you keep it trimmed. All of these are easy to grow easy to find houseplants that are perfect for a busy man. Try and find plants that all take basically the same care. Makes it easier for you.
If you like cactus, there are loads of adorable small cacti that are fun to grow. Ever try and make a little rock garden with some sedum or cats and kittens(chicks and Peeps) whatever you call them, in a larger container near a window. You are into photography and obviously artistic, so picture what you want and the plants are out there to make it. Hope this helps. Use your imagination...that always works. Have a good day.