Simple comparison of full moon shots comparing S23 Ultra photos in:
(1) Pro mode (left) with full manual settings, focus sharpest at 6.2 with the maximum x20 
zoom available, and the same image zoomed in (centre cropped) to show similar aspect as (2) pict.
Mar 23 7:28 am ISO-64 1/180s x20 zoom

(2) Standard Photo mode (right) zoomed to x71 with Scene Optimizer enabled which auto performs 
multi-image averaging to lower "noise" and enhance detail.
 Mar 23 7:23 am ISO-50 1/180s x71 zoom

Photos are as taken, not adjusted (except for centre cropping) in any way.
The Pro mode shot zoomed in has more noise (grain) which presumably the Photo mode + multi-image stacking 
in Scene Enhancer effectively removes but the level of detail is comparable with some contrast sharpening in the Photo/AI mode.