I couldn't agree more with the overestimation of light and how insignificant light can never yield a thriving plant. BUT, for those that can survive anyway, some long-time low-light specimens are quite unique with a survivor characteristic with which a normal looking plant could never compete as far as being simply interesting.
After moving from OH to AL, I finally understood how a different location could affect house plants inside so much. The winter rays in OH are always going to be weaker, and, generally, there will be many more sunny hours over winter in AL. But there are plenty of plants that are never going to be happy here, like those that can't take high temps/humidity during summer, are total divas about some low humidity during winter, can't live through temp fluctuations of about 45-95 from being in unheated rooms for winter and outside for summer... those that can't survive variables beyond my control & the conditions I have to offer.
These last comments of mine and other people speak to the topic and assure us that nobody has a black thumb, but inappropriate expectations and inexperience are common. Both can be eliminated but nobody can keep every plant alive indefinitely. Don't take losses too hard, there are plenty of other plants to try.