I think the Huawei P40 Pro is currently the best camera phone, but I worry about full Android compatibilty of Chinese phones, so I use the Samsung Note which is almost as good.
I had a Note 8 for 3 years, and was very pleased with the camera performance (but not the battery life), and have just replaced it with a Note 9.
There's been a Note 10 and a Note 20 since the 9 - but I just feel $1,100+ USD is too much for something I keep in my pocket. But a brand new 512 GB Note 9 is available for around $450, and it's spec is not that different to most current high end phones:
- Dual cameras
- Primary: 12MP (1/2.55-inch sensor, dual-pixel PDAF, f/1.5-2.4 variable-aperture lens)
- Secondary: 12 MP (f/2.4 lens, 1/3.6-inch sensor, AF)
- OIS on both cameras
- Single LED flash
- 4K video at 30/60 fps
I added a 512 GB SD card, so have 1TB of storage, that's more than my laptop.
I have to say the camera performance is only a small incremental improvement over my Note 8, but that's the way with most new phone or camera releases now, but battery life is sognificantly better with a big 4000 mAh battery.
So my recommendation - go for a discounted Samsung Note 9 or 10+ and save $500 and still get a great camera phone with a unique variable aperture lens, and an integrated stylus that is good for photo editing and it also works as a wireless remote shutter release.