Most project I see (and all I work with) use Postgres and I am very happy not to waste time on researching 50 ways in which using any 2 mysql features together will shoot you in the foot. There is huge amount of interesting projects bult on top of pg (like timescaledb or edgedb), every provider I know can host it so overall I'd say that using mysql would be a limitation at this point.