Trying to find a good straight-up camera in an Android phone

I've had several phones, but to give an idea of what I like, I'd have to say the best photos were taken on the following:
- My Nokia Lumias in the Windows Phone era
- My Google Pixel 8 in completely manual mode, especially with Open Camera. In auto mode it was horrifying fighting constantly with their awful algorithmic image balancing
- My Xperia 5ii, with the only caveat being that the shutter button in the pro app provoked many blurred photos. But the video and photos were of DSLR quality when lit and stabilised properly.

What's important to me:
- I need to have a camera on my phone that's going to take the cleanest, least doctored image possible. Don't want to constantly be fighting image processing software like what my Pixel 8 did on auto. Infuriating.
- amazing night photo capability is of no importance to me. I come from film. Night is night. If you don't have exposure, you don't have a shot, full stop. I like naturally dark images.
- 24fps video shooting a must. Ideally not as massive as 8K (as on Galaxy phones) and I don't even care if it's "only" FHD 1080p for smaller editing file sizes.

I thought I was honing in on the Xiaomi 14T Pro, but I started reading things online that suggested the image quality and dynamic range were severely lacking. So I appear to be looking at the Galaxy S23, Oneplus 11 or 12, or a newer Xperia than my 5ii range. I'd like to keep to a 600€ or $900CAD budget.