I think a good reference is Apple's "retina" brand [1]. For a 27" monitor to be (basic) retina it must be 5K. But yes, there are diminishing returns and resolution isn't everything (I've tried terrible 4K monitors...).

[1]: https://en.m.wikipedia.org/wiki/Retina_display