Have only had my 2018 Mini for a week now, but I'm completely happy. Am using a 32" BenQ 1440p display and it looks great at the native resolution. I would rather have this big screen than an iMac running at a scaled resolution.
At this moment I have Windows 10 running a professional GIS application in a 16gb Parallels VM and it's noticeably faster than my old dual core i5 Windows 7 computer. I also have MS Word, Photoshop, Mail, Messages and Safari running on MacOS at the same time. The Mini is a bit warm to the touch but is absolutely silent. I'm sure the fan must be running but I can't hear it, even when I put my ear next to it.
Now, mine is an i7 with 64gb of RAM, so maybe that makes a difference? Activity monitor says 27gb is currently in use. I decided against getting a 4k or 5k monitor because it would have to be about 42 inches for the dot pitch I want at native resolution (don't want to read tiny text).
Anyway, seems like it's all about finding the right combination that suits your needs. Perhaps the Mini isn't a good choice for those who want 4k or 5k and scaled resolutions? But I really don't see a problem with 1440p and am sure I wouldn't be as happy with a 7-year old Mac Pro. I already have too many vintage computers and wanted something new, not another "orphan".
Yes the computer is smooth at 1440p. But it's definitely not ready for 5K, the LG display is supposed to be the perfect companion for the Mac Mini and it's not, Apple is lying. Even with an eGPU, it's not working perfectly smoothly.
For me this Mac Mini is a temporary solution waiting for something better in a near future. I don't see myself keeping 5 years a computer that is already struggling for some tasks after just a week.