Depends where you live
Most house plants will survive in places where they do not get any direct sunlight
There are several varieties of "parlor palms " that do well in darkish places .
Most rainforest ground covers or understory plants will grow happily in low light with no direct sun light as the forest canopy prevents this happening .
As for watering , things like maiden hair ferns need to wet nearly all the time while other like to be dryer it will depend upon the plant .