What is drawing people across

Stricter typing, richer JSON handling, window functions, real check constraints, and extensions that add capability without leaving the database.

Where MySQL still wins

Ubiquity. Every shared host supports it, every hosting panel manages it, and replication tooling is mature and widely understood.

The migration question

Rarely worth it for a working application. Worth serious consideration for a new one, especially where reporting or data integrity matter.