I long for the days when all that was running on your computer were things you commanded it to run, not things that the OS vendor wants running at all times for whatever (nefarious or otherwise) purpose.
Another cause is that Apple and Microsoft are now service vendors, and they want to sell you subscriptions to Apple {Music,Arcade,TV+...} or Xbox Game Pass, and they also have app stores where they want you to buy things. The services and apps aren't necessarily bad, but they also tend to add more daemons.
Finally, security has been a terrible issue since mainstream operating systems and apps were not designed to be secure (which admittedly is very hard!) and customers usually prioritize features and performance over security and reliability. Apple and Microsoft have tried to become more security-conscious but this has also made the systems less usable and added anti-malware daemons that do annoying things like phoning home to check if an app's developer certificate has been revoked, or repeatedly re-scanning files to see if they match a newly updated list of malware signatures.
Atm Mac OS seems like the least shitty option (mind, not the best, there is no best) so I mainly use that.
Divide and Conquer.
Millions of users against •one• company.
Resistance is futile. Users adapt.
Spotlight/mds/mdworker/... has been a monstrosity since forever, but the accursed macOS daemons that earn my unending ire are photoanalysisd and syspolicyd. (The former probably runs on iOS as well but I mitigate it by deleting photos after import.)
Whenever I pull my laptop out of a bag or backpack and it's unreasonably hot, photoanalysisd or syspolicyd are usually to blame, scanning the same files again for the 1000th time. I haven't enabled smart nap, so this must be the "stupid nap" functionality.
There doesn't seem to be any easy way to disable these evil daemons without messing with SIP etc. Even if you disable awful misfeatures of Photos like Memories, photoanalysisd still runs. Syspolicyd doesn't have a UI. At least with spotlight you can disable it on certain volumes, though of course that breaks Mail's search function.
Regarding 100% CPU, I wonder if low-power mode would help? iOS low-power mode seems like a great feature, but unfortunately it turns itself back on after the battery charges.
Funniest thing is that ease of access/availability of photos in other apps hasn't improved much so what's the point of the overkill photo DB. Better use the filesystem at this point...
In the 2000's, Windows Explorer on Windows XP had a feature to preview media files, but when it encounters a large video the system doesn't have a codec for...