The camera isn't "bad" but it isn't good either.
For point and shoot, 12mp is your go to. 50mp has recently improved to be similar to 12mp.
200mp may get the headlines but it is poor by comparison.
In all cases, zooming more than about 2.5x will wreck your image. Zoom is poor on all cameras in my view.
Samsung have never addressed the issues with S24 cameras and I would always recommend an S23 Ultra over an S24 Ultra on this point.
S24 Ultra