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.