"Spider plants" though not always super-attractive, are also resistant to abuse. I've also had good luck with Jade plants. I have a dark little hole of an apartment too--so far, it's only flowering plants that don't survive. When I need color, I have to pop for cut flowers and hope they last at least a week. Good luck and post what you do!
Funny, my jade plant I got from my grandmother-in-law didn't survive a week! I do well with cacti & spider plants, like you mentioned, in my apartment. I don't have windowsills, but I have lots of windows & a bay window in my living room. I've done well with ivy's, too.