This is one of those fun situations where everyone's right.

The upstream default has changed, but CentOS still uses the old default.

Almost every distro I know turns this option off by default, including Arch, NixOS and Debian (the last one I am not sure).

It defaults to "no" on Debian 10. Maybe Fedora changed the default?

Fedora does not have this feature on: https://src.fedoraproject.org/rpms/systemd/blob/265d91aff516...

That's most interesting, given that both systemd and Fedora are Red Hat products. If there's one distro that would use the systemd defaults, I would expect it to be Fedora. Who exactly are these defaults for, then?

I've mainly seen it switched on for appliances and things that don't really have a legacy of this behavior.

It's not switched on in RHEL or Fedora. It's likely to never be so.