Backup has the same issues, given that you always have your backup drive attached to do 1-hour interval TimeMachine backups. However, my backup drive doesn't spin up/down just for the backup. It randomly does so several times during that 1hr and also whenever I access files on my external SSD through a file selection window of an app. It is really annoying, especially because I have 18TB server drives that are inherently noisy during spin-up/down.
OTOH, I also can't get my Mac Studio to properly sleep when I tell it to. It will randomly wake up and of course, spin up the attached drives. This is due to the multitude of background services that Apple has built in, like "Find My" and the like. The only way to turn these off is through the terminal but that completely disables them. I want these services to work when the computer is turned on but I want the services to stop nagging when the computer is asleep. There seems to be no way to achieve that. It is frustrating, to say the least.