I'm sure there are many plants that would do well on a windowsill but I don't know of many plants that will thrive for very long with poor drainage ... the roots would end up rotting.
~ I'm an old gal who still loves playing in the dirt!
~ Playing in the dirt is my therapy ... and I'm in therapy a lot!