Earlier quoted context omitted.
What settings are you shooting? How do you edit your images?
On my Z5 I can use the built-in Landscape mode, and on the Z6 I can use auto or manual. Autocorrect RAW in Adobe Photoshop looks good. And certainly on a 4k monitor the DSLR images reveal more detail. My post here has me realizing I need to take iPhone and DSLR shots side-by-side in the same place with the same lighting and begin to compare them in-camera and in post-processing.
Popular notion is that at f/11 only will diffraction start to affect you, but with modern high resolution cameras diffraction starts to creep in as early as f/9, so f/5.6 is generally best unless you really need the deeper field. You're probably going to be fine at 24MP, though.