I have spent weeks looking for the best display for my 27″ 5K iMac. (Now I’m using those monitors with Mac Studio.)
Apple Store has long sold a third LG UltraFine in addition to the 27″ 5K and 21.5″ 4K, which is not shown in the image attached to your question. It is present in the article @benwiggy linked in the answer. That monitor is the 23.7″ 4K LG UltraFine.
According to technical specs, its PPI is 183, which is in the “bad” zone. However, I have been using two of these monitors for years and have never seen my GPU race unless I’m gaming. (Yeah, I used to play games on macOS at 60 Hz. My teammates hated me.)
It costs $700 in the US, so you can effectively purchase two 23.7″ LG UltraFine for one Studio Display. However, these monitors do not have a camera (which I prefer because my Mac Studio uses my iPhone camera, which is superior and “upgraded” when I purchase a new phone).
In terms of coding compatibility, you will have only one problem with these: If you connect to a Windows machine, you cannot control the brightness and resolution. That is a typical issue with any product made for Apple devices.
This display is very sharp and 500 nits bright, which is what my iMac used to do. I can wholeheartedly recommend this monitor for everything you do on Apple devices. I also use it for external iPad displays. They are daisy-chainable if you decide to connect more of them later. Also, I have set mine up on a VESA mount, so one monitor is in portrait mode for reading long lines of code, and the other is landscape.