Auto updates can cause problems. Some recommend it, some tell you to not do it. My standpoint is, when a container can't work with auto updates, they suck. Sure there are containers who require some additional attention after an update, like gitea with some config changes but I use it in an environment where it can be offline of some time.
If a container uses Postgresql, you can't auto update. So far I didn't found a well maintained container, that can do this. You also should keep an eye on your containers. As I mentioned, Gitea had some config changes, breaking the default theme (nothing major). They even screwed up their tags and I had 3 times an RC in a tag where no RC should get published. With Jellyfin I was on a tag that didn't got any updates anymore and I needed to use a different one.