In an attempt to bring the thread back to the main question...
Since all the major camera brands are moving to mirrorless, that really is the future. However, for many folks who are happy with their current DSLR systems, there is a question of whether to/when to look at upgrading to the current generation of mirrorless cameras.
Some of the important issues that have been mentioned in this thread are:
Autofocus (AF) speed and reliability
Wide angle shooting into the sun
EVF verses OVF viewfinders
Underwater my experience of digital cameras is only with Nikon: D200, D7100/7200, Z7II
On land my experience of digital is (including the above) is: D850, D810, D610, Z7
So for a Nikon shooter I can give some perspective. I know nothing about Sony or other systems for UWater.
For AF the D850/D810 are superior to the Z7/Z7II - no question. For wide angle I will suggest that the difference in AF is not relevant, I've had no issues with the AF of the Z7II for doing underwater wide angle. For macro, the Z7II AF is prone to hunting and moving to the wrong object (my experience) but once I get the subject the way I want it minor AF changes work well and the EVF helps a lot for composition and nailing the focus (see below)
For wide angle shots into the sun. I find no difference between the mirrorless and the D7200, they are equally hard to get a nicely balanced exposure. I can see the sun just fine on the Z7II. For me, getting the sun exposure dialed in is challenging regardless of system type, but I never felt that seeing the sun in the EVF was the problem - it was the same as ever, getting a composition, getting a model into a decent position, balancing exposure in the foreground (strobe power) with the sun exposure (f stop/shutter speed combo) and other familiar challenges.
For the EVF v. OVF questions. I prefer the EVF, I can see everything I want to see. I have a sharper and brighter view of my subject. For macro I have been able to get a far greater number of properly focused images of small critters than with the D7200, especially for super-macro with a diopter. The other advantage of the EVF is that I can see the composition and the exposure of the image in the viewfinder without moving my camera from the subject. This makes it so much easier to refocus, modify strobes/camera settings since I don't have to move away from the subject or move the camera to view the screen on the back. For me the EVF is a great step forward.
Now, for someone who has a complete D850/D500/similar DSLR setup, the question is what's the point of upgrading and spending all the money to do. In my opinion there's not too much reason for it at this point. The D850 has better AF, you have a system that you are familiar with, you have already spent the money. The D850 and Z7II have essentially an identical sensor (I know there's a several year technology gap, but there's little to choose between them if anything) so switching to the Z7II is barely, if at all, going to change your image quality.
The Z system mirrorless housing is essentially the same size as a DSLR one so there's barely any advantage there. If you use 8 inch (or greater) domes then your pain will not be reduced by switching.
Now, if you are looking for a new system, moving up from a compact camera or just starting out there are different strategies. You can get a used system for a fraction of the cost of buying new. D850, D810, D7200 etc. are all available for very decent prices and you can put together a great system for a fraction of a new Z7 system. You will be happy with the image quality. No question.
Or you can look into the high end mirrorless systems. Your budget will be way higher, you will have great image quality. You will most likely be happy with the images.
However, as pointed out by @Edy park and many others over the years, the real thing to work on is improving our composition and lighting skills. A new camera won't fix those things for us. A new camera may have some features that can help us with exposure or getting setup to take an images but it doesn't improve our skills, only practice and study will do that.
OK, so why did I upgrade then and spend all that money? I upgraded because I had already switched from using my D810 for landscape and other topside images to a Z7 and I was moving to mirrorless anyway. I wanted the ability to get better video than the D7200 offered underwater. I have always been unhappy with my Tokina 10-17 image quality at the edges so I was looking to switch to the 8-15mm and would need to get a new mini dome anyway. I wanted to switch to optical connectors so I could add the Backscatter snoot system. yes, the upgrade cost was huge, it was painful, and while my wife knows it was expensive, she doesn't know how expensive
But, for me, it's been fine to make the change with a small learning curve.
Hope this helps anyone who is interested.
Jon/Rinjani