Does using "Content Type Publishing" over-complicate future plans for migration and file movements

Question

I have been a SharePoint developer since SharePoint 2010, but never used "Content Type Publishing", mainly that it cause lot of issues when i try to use them, such as:-

1. Some changes on the "Content Type Publishing" such as adding new column will not get published to all lists especially when we have lot of sites and lists, leaving the content type on the "Content Type Publishing" un-synced with the content type on the list/library level. this was a regular issue in SP 2013.
2. Some sites will already have site columns or list columns with the same name as the "Content Type Publishing" columns, which can leave things unpredictable
3. Also migrating SharePoint on-premises to online was not straightforward when the on-premises were using content type publishing.

also, still most of the top-rated migration tools have lot of instructions and warnings about "Content Type Publishing" (which i do understand) such as but not limited to https://help.sharegate.com/en/articles/10236609-content-type-hub-limitations

So I always prefer to use site-scoped content types, of course we might have the same content type and site columns managed separately on different sites, but at the end we can manage this with the use of PowerShell or even manually manage those. also search service which most of the web parts reply on when retrieving content from different sites, does not care so much if we have 2 site columns with the same internal such as DocumentType, but been managed inside 2 separate site. as the 2 separate site columns will have the same crawl property and the same managed property. so for example, when we want to get documents with document Type = "Policy", this will retrieve content for the separate sites automatically.

So can anyone advice about using "Content Type Publishing" Vs site-scoped content types?

Thanks