sure, there are growing platforms that generate revenue for them, but from what I've seen, it's all dependent on volunteer donations.
I suppose it would be a dream job to get paid to develop my own code, but developing a closed commercial software product seems like an easier route to success. Linqpad is one that comes to mind.
All code needs maintenance of course, but some types of projects require a lot less than others.
For me, creating software is an expression of Creativity. I to be able to explore my creative interests. Not those of someone else. I want to create things that interest primarily myself. I suppose the key to that success is to find a topic which has enough people are of interest that would be willing to give me revenue to work on that topic.
An "Ultimate Guide on how to make a Just-A-Little-Bit-But-Not-Overwhelmingly-Popular Open Source Project" would be much more helpful :)