On my S24 Ultra I'm finding video at 8k 30fps works really well.
In photos, I find 12mp and 50mp work well as long as not using zoom beyond 3x. After 3x then image quality drops quickly. 200mp camera needs work.
I have seen incremental improvements over the months, but not a huge improvement in any one update.
S24 Ultra