When I bought my Fuji X-T5, which is a 40mp APS-C camera(AFAIK one of the highest pixel density ILCs on the market-it would be around 90mp if the sensor were stretched to full frame) I was afraid of what I would see with noise.
In the real world, I haven't found it to be as much as I was afraid of. It's not as clean as my D850(45mp full frame) but honestly if I put two files here from the two, both at 12,800, I doubt you'd be able to tell which came from which camera based on noise alone.
With that said, the cleanest 35mm format cameras still, in my judgement, have to be the full frame relatively low resolution bodies. I thought the Nikon D3s was good, and it was and still is, but then bought a Df(which uses the D4 sensor) and found it even better.
The 20mp D5 got a bad rap because DXOMark ranked it low based on its base ISO being(relatively) noisy and having poor dynamic range. I overlooked the camera for a long time for that reason, but I kept hearing anedotal reports from real users talk about how it really starts to shine at high ISOs(and how nearly perfectly files come out of the camera). I finally bought one myself and, yeah, it's incredible. 25,600 is cleaner than 12,800 on my D850 even after downsampling the D850 files to match the D5 size. When I first got it the 51,200 setting scared me but I finally cranked it there one day and yeah it's noisy but not much worse than 12,800 on the D850. I've never used the 102,500 setting in the "real world" but I would if I needed to. BTW, 102,800 on that camera is a real ISO and not an artificial "boosted" setting. It holds color fidelity(the boosted settings don't) and smears detail along with being relatively noisy but it sill looks better than a D2X at ISO 1600. That to me is unreal-102,800 should let you take handheld photos by candlelight with an f/2.8 lens.
Long story short-I don't know that there will ever be an APS-C camera with performance like the D5(and presumably the D6) but they are perfectly respectable. 12,800 is enough for me to get handheld sharp results with an f/4 lens and VR/stabilization in situations dark enough to make reading difficult. That's good enough for me most of the time-I only go to higher ISOs even on the D5 if the situation calls for more DOF and/or shutter speeds fast enough to stop action. Nikon seems to like the 20mp sensor that first showed up in the D500 for their APS-C cameras these days. Its pixel density is similar to their 45mp sensor that they use in almost all their current full frame bodies and ISO 12,800 is great.
BTW, the ability to crop to APS-C in-camera from a full frame lens is hardly a Sony exclusive feature. Every Nikon full frame DSLR I'm aware of has available an APS-C crop mode. It does need to be manually selected, which I actually like since some DX lenses actually will work as full frame lenses(Nikon's cheap and light 10-20mm AF-P is often in my bag because it will give full frame coverage at 14mm and wider, and weighs a fraction of what the 14-24mm f/2.8 weighs). I understand the Z cameras force DX crop with no option out of it if you fit a DX lens. There are some cameras that will run at a higher frame rate in DX mode, like the D850.