Depends, for example Debian unattended-upgrade caused system restarts after many updates that was extremely inconvenient for me because I have a more manual bringup process. I had restarts turned off in its settings and it still restarted.

I uninstalled it and have not one single unwanted restart since then, so manual upgrades it is.