The LG that you included is the direction I would go. A 4k screen will be way more flexible and elements will look much better than they will on the 2560x1440 options you've included. Scaled resolutions work just fine in MacOS. They just don't look as good as the 220 pixel per inch Apple displays, but if you want the Apple display quality, you have to pay the Apple price. No one complained in the era when MacBooks used a fractional scaling as the default resolution even though it took a bit more GPU resources and likely had a marginal effect on battery life.
With a 27" display at 163 pixels per inch, the pixels are too small to use at full native 4k resolution, so you will be stuck in a scaled resolution. Things will look sharper than they do on a 110 pixel per inch 2560x1440 display because each pixel is smaller. You may find a resolution that sits between 3840x2160 and 2560x1440 that provides a nice balance between screen real estate and the size of onscreen elements.
That said, when I got my mini, I ended up going with a 32" 4k LG monitor. At 139 pixels per inch I still feel comfortable reading menus at full 3840x2160 resolution, although I do bump up default font sizes/zoom in text-heavy apps a bit to be a little more accommodating when I'm reading while leaned back in my chair. I find that pixel density provides a nice balance between being useful at full resolution or being able to run at a scaled resolution if I wish. 3008x1692 as a scaled resolution looks quite good, 2560x1440 isn't bad, but the pixel doubled 1920x1080 and lower resolutions just do not look good to me.
I highly recommend going for a 4k monitor whether it is 27" or 32" for your mini. I just got tired of looking at modern versions of MacOS on my 21" 1920x1080 110 pixel per inch displays and found and option where I could consolidate my day to day work onto a single screen instead of duals screens. For me, 32" @ 4k was the right choice. I would have been equally frustrated with a 27" 1440p display because it has the same pixel density as my old 21" monitors.
