Some projects were successful at charging for custom work and special support — sqlite for instance.

Exactly, that's an example of a top 1% project. It even has a detailed Wikipedia article in 35 languages. That model won't fly with small to medium-sized, regular projects.