Few companies have done it successfully like Red Hat, Odoo ERP and Sensio Labs (the company that builds Symfony framework).

Yes but notice how all of those are B2B? I was responding in the context of B2C, on one hand we know that people are willing to pay for convenience - Steam has largely beaten piracy by simply offering a better service.

But that wouldn't hold up if games were released under a FOSS license. There would be nothing stopping me (maybe trademark law? I'm sure there are workarounds) from setting up "SteamForFree", rehosting every game with the same user experience as Steam, and offering access for a small monthly fee to cover hosting costs and make a tidy profit.

I'd like to offer source code, allow modifications for personal use, while prohibiting redistribution and certain types of commercial use (e.g. companies over $x million in revenue). That's a pretty fundamental mismatch between what I feel comfortable with in order to protect my income and what FOSS licenses allow.

Fully agree with this sentiment.

I do think though that disallowing "certain types of commercial use" is a poison pill that would prevent your project from getting any significant adoption.

I think a better option would be something like GPL but with the "you can redistribute copies of this to anyone you like without paying me" part stripped out. (Maybe replaced with a provision that allows transferring your license to someone else, but then you're not allowed to use it afterwards.) The goal being to protect consumer freedom to exercise ownership rights over their software (including the ability to modify it) without simultaneously trying to abolish the copyright system and killing your own funding mechanism in the process.

I still think you'd get the part of the market that cares about creators. The part that doesn't would pirate anyway. Now, this is assuming they can determine that you are the original creator, but IMO this is what trademarks are for.

Sure, some would. But in the general case that's going to be a tiny fraction of the market. Why would I ever do that when I can simply not set myself up to be screwed and instead use a license that aligns with my definition of fairness?

Remember that people regularly walk into small businesses and spend 15 minutes talking to an expert asking questions about the products they sell. As soon as they get quoted a price of $120 they scoff and order it from Amazon because it's $20 cheaper. Consumer price sensitivity is... extreme.

Notice all three of those companies make their money selling support contracts to businesses, not selling software to consumers.