Ubuntu has always worked for me.
Make sure you enable proprietary drivers in the installer and check the additional drivers app in Ubuntu.
Windows always requires you to download replacements for their garbage(MS Edge, OneDrive, etc)
Ubuntu Generally works out of the box.
Getting Old GPU drivers is a problem, but that is always the case, regardless of the OS.
Ancient hardware is always an adventure
One important drawback and benefit of Ubuntu is its multi-package nature. Updates are not from one central company, they are many small updates. This can be annoying, but it also allows you to keep 100% up-to-date all the time. If a new version of one package is incompatible with your hardware(Like >5.15 kernel and NVIDIA driver 390), you can choose not to update that piece while still updating all other pieces to their latest version. Security updates are still provided for LTS versions. Windows just ditches you after like 5 years.
Get Ubuntu PRO.
But don't use livepatch unless you really hate restarting your computer and you have new hardware that won't get broken by kernel updates.