I too am not a fan of the size and weight of the larger housings, but can add my story to some of the others.
A few years back a had a D850 in a Nauticam housing. As said above, I hated the size and weight (but was extraordinarily pleased with the photos / usability). To "fix" the issue, I moved to an A7RIII hoping to reduce size. It was smaller, but when I added strobes and a dome port life was much the same. Yes, it was smaller, but not in a really important way.
So now I'm wishing for an integrated solution the size of a GoPro. It would include a 13mm rectilinear lens (water convertible to fisheye and macro), Retra strobes with combined 10K video lamps, and Sony A1 performance.
Somehow I think I'm going to be disappointed .... 😥
Gary