I have started using linux for 6 months since I leave Windows and already tried ubuntu, arch and liked mint besides arch AUR be so useful, but because I have had some issues with rolling release I choose mint, and I sometimes need latest package, there is somehow to install without being though appimage and tarball?
Yeah if they want to update system packages it's where things end up in dependency hell. You want newer X, it needs newer Y, it needs newer Z and it's a a library half the packages of the system depends on and the rest of the system goes boom.
It's actually why I went to Arch, I need to hold back packages way more rarely than I want newer everything else.
Your only option is universal formats like Flatpak and AppImage. I would recommend against random deb packages or compiling from source unless it's some very tiny obscure utility that will not need any updates in the foreseeable future (so something like j4-dmenu-desktop or a fetch script).
I forgot about PPAs - I don't normally use Ubuntu-derivatives. PPAs are a little more dangerous if I recall correctly right? Firstly it should be an official PPA from the software developer, and secondly because it's a repo you have to make sure that it isn't going to eventually pull in packages that replace/break your system.
Safety for the ones I've listed:
Flatpaks - Containerized, separate from system packages
Cargo - Manual compilation, /home installation
deb-get - One-off .deb from official source and doesn't try to pull any other dependencies in - worst case you fail the dependency check I think?
Homebrew - Pre-compiled binaries or manual compilation if you choose, /home installation with local dependency network
Nix Package Manager - Roughly the same as Homebrew, /home installation
bin - Probably a single statically-linked executable, /home installation
Docker - Containerized, separate from system
Compile and install it yourself - Highest potential for things to go wrong as you're messing with system packages and probably working off of some developer's questionable compilation instructions (or even lack thereof).