On x86, maybe. Try booting an M1 Mac, turning off the screen (without closing the lid - that's what makes it go to sleep instantly), SSHing in, and running a shell loop that prints out the date every minute.
I left it running and the thing didn't even drop from 100% battery after 3 hours, when macOS finally decided to go into real standby and that killed the connection. Did it for another 3 hours and I was at 98%. That's 2% battery usage per 3 hours for a system with an OS running, active WiFi, and an open TCP connection.
"Modern standby" works when your hardware has good power management.
FWIW, I've never seen an M1 go into hibernation other than when the battery is about to die. The normal lid closed state is true sleep, not hibernation. You can tell because waking up from actual hibernation actually takes a progress bar and a few seconds.
As a gnu/linux person forced on Mac for work, this was what I settled on that worked reliably for me. (I found I would often crash iterm2 or alacritty and lose my terminal based caffiene commands)
I'm pretty sure they both work through the standard power assertions API[0], so nothing precludes having both (in fact if you have amphetamine you necessarily have both) and using whichever's more convenient for your needs at any time.
Unlike AlDente (versus native) there should not be any conflict between caffeinate and amphetamine, because both simply signal to the system that some forms of sleep / power saving should not be used. If caffeinate says the disks can't idle-sleep and amphetamine says the system can't idle sleep, then neither will happen and that's that.
[0] https://developer.apple.com/documentation/iokit/iopmlib_h
"modern standby" is such a scam and shit show.
And completely opposite that, I was a bit shocked how aggressive modern macos (at least on M1 machines) are at hibernating, I have had to get used to `caffeinate` long-running process because on battery if that's not in use as soon as the screen turns off the machine stops doing anything, even with "low power mode" disabled.
I expect there's a pmset somewhere to change that (as there is an option in the UI when on power adapter), but with the battery life of the new devices I've kinda stopped plugging it in (even at my desk).