If you install from source, applying upgrading & security fixes is on you to perform. If you use a package (be it snap, deb, flatpak, appimage etc) it's dependent on the package type & method used and if you've provided sources to it.
deb packages will be release specific so if using the latest release (currently 23.04) you'll get the latest, if using something older (such as 22.04 which was 3 releases ago) you won't be (usually!).
snap package & other package types give you the same regardless of your OS/release (ie. 23.04 & 22.04 use the same snap package; though you can influence that too via channel selected by installer).
If using the deb format from default OS repositories, you'll have no issues with release-upgrade when that time comes... if you use a later source (eg. PPA) that may give newer software.. you'll may have problems come release-upgrade time... ie. What you're asking for is opinion where the best will be determined by your requirements (new vs. old software), how long you'll use the system (ie. release-upgrade is how big a concern for you in the future etc, or are you happy to resolve issues when that time comes) etc...
We have choice, pick best for your needs.