Non-commercial clauses seem to be a good fit for software that is someone's "day job" where they charge for licenses. It's not common, but I've run across the following projects:
Duplicacy by Gilbert Chen https://github.com/gilbertchen/duplicacy
Dome by Federico Milano http://faraday1.ucd.ie/dome.html
Fman by Michael Herrmann https://fman.io
From what I've gathered, success has been mixed. Duplicacy seems to be doing well based on forum activity and release history. Fman never made much money. If I recall correctly the Fman author was turned off by the number of people who criticized it for being fully open-source and wished he'd stuck with a closed-source full commercial model. I'd like for the open-source community to be more accepting of this model as there is potential value in it. As an example, Mathematica still refuses to let anyone not employed by the company see the source code, which creates a reproducibility/validation problem for math researchers. While Steven Wolfram understandably rejects pleas to make the software FOSS, there is real benefit in letting people see the code.
Edit: Fixed names