It does indeed make setting up a headless RPi quite convenient, although afterwards you do actually have to find the thing on your network.
By default it has the hostname "raspberrypi" and handles mDNS so SSHing to raspberrypi.local often does the trick, but could be a problem if you have more than one. You can set the hostname in the imager to deal with that.
Another common approach is to check your router's DHCP client list or connected device list. If you are lucky your router includes the hostname if the client sent one. If it only shows MAC address, IP address, and DHCP remaining lease you can look for something that just got its lease.
Personally, once I learn the Pi's MAC addresses either from my router's DHCP server or by logging on to the Pi and using "ip link show" I go to my router's DHCP settings and assign reserved IP addresses to those Mac addresses. Then whenever I re-image or boot from another drive with a different image it doesn't matter. It's going to be on the same IP.
If you just want a small, cheap computer, x86 boxes are better in every way.
But if you want something you can hook wires to, fry once in a while, and find 20 blog posts about someone doing the same, Pi still has a niche that’s hard to replicate.
All I’m saying is that Pi projects can get really expensive if you want to do anything beyond a basic install like Pi-hole and leave it as-is. Even simpler projects - say, connecting a motor or a servo require additional components like a power module or distribution board, which quickly adds up.
You can connect things to the headers and experiment with it as originally intended.
In my opinion, it doesn't make sense to try to treat it like a mini desktop computer. Like you said, it's very expensive to add on all of the accessories: High power adapter, M.2 hat, SSD, special HDMI cables, and a case for cooling. By the time you're done, you've spent as much as a cheap x86 computer that would outperform it and come with none of the software quirks.
Just because you can outfit it will all of those things doesn't mean most people should. If you really want a mini computer, get a mini computer.