I already use a form of Debian Ubuntu, I am pretty okay with it. This is my transition to Arch.

You can very easily jump to the Testing or Unstable branch on Debian which will give you access to a lot newer software, not the absolute latest, you’ll be 2-3 months behind depending on the specific package and branch. One thing that must be kept into consideration if you switch away from the Stable branch is that security in the Testing and Unstable branches is more of an afterthought, so if you’re comfortable running less secure software you can do it, otherwise, if security is imperative, you might want to stay on Stable, there are countermeasures you can take to make these branches more secure, especially Testing, like pulling browsers from Unstable (as recommended by Debian’s own documentation) but ultimately they’re not designed with an heavy focus on security. Another solution would be to stay on Stable and pull the Kernel from bookworm-backports, which I think ships the 6.5. Kernel, and then you can grab the graphical drivers (Mesa and/or Nvidia) from the Experimental repo, which are way more up to date than the ones in Bookworm, this should not introduce issues and is, again, explained in the Debian’s own Wiki and recommended if you’re running newer hardware. Lastly, if you need the absolute latest Nvidia driver, you can grab it from Nvidia’s own repository, at the time of writing the latest driver is 545 which can be grabbed from the Nvidia repo while the Experimental Nvidia driver sits on 535, while Stable, Testing and Unstable all use the 525 driver, which is starting to get quite old since it came out last year.