Why bother, and why the trend is real
The case for the move is mostly the case for having your DNS somewhere deliberate. One screen with every record on it, changes that take effect promptly, an audit trail, and DNS resolution that is fast everywhere. Add the certificate, the caching and the filtering in front of your site, and the free tier covers what most small business sites actually need: the honest assessment of when it does not is on the service page.
There is also a quieter reason. DNS scattered across an old host's control panel, managed through a login nobody quite remembers, is a liability waiting for its moment. The move is a natural occasion to take inventory, get the records documented, and end up with the whole zone somewhere the business itself controls. The terms this page keeps using, records, nameservers, MX and the rest, are all defined plainly in the domain and DNS glossary.