As far as the basics of taking images are concerned, the technology has plateaued for a while now. As I understand it, the sensors are sensitive enough to detect single photons - there isn't really anywhere to go from here. Where the advances are being made are in ancillary features such as tracking autofocus - the latest generations of cameras have varying degrees of subject detection and recognition, and sensor readout speeds continue to improve, which is useful in supporting the latest AF tech. The 'fastest' sensor technology at this time is stacked CMOS, where memory is integrated into the sensor, and this is used in only a handful of cameras - Sony A1 pioneered it, and it was followed by Nikon Z9 and Z8 (basically the same camera with Z9 have an integrated vertical grip), Canon R3, Fujifilm X-H2S and OM Systems OM-1. Notice how those are all extremely expensive flagship cameras - A1 MSRP is $6500, R3 is $6000, Z9 is $5500, Z8 is $4000, X-H2S for $2500 and OM-1 is $2200. OM-1 Mark II has just been announced with MSRP of $2400.
However, for your stated use case, all those "speed, speed, SPEED" features are largely irrelevant. You're not shooting fast-moving sharks or dolphins, nor are you doing macro in surge and current or blackwater. If a wreck is going somewhere, I dare say something has gone very, very wrong, and you are unlikely to be concerned with photography at this point. For a completely static object, even manual focus is going to be fine, and in certain cases might be preferable over AF.
Therefore, you need to work back from the type of shots that you want in order to decide what type of lens and camera that you need. Is barrel distortion okay? Are you prepared to carry large, heavy glass? Can you deal with longer exposures? If you want panoramic shots of wrecks, then carrying strobes might be counterproductive - you may be better off getting a bunch of video lights with tripods and strategically positioning them around the wreck to light up specific spots; for example if you have an enclosed bridge or a conning tower, place some lights inside to light up the windows. As far as camera goes, something like an A7R III or a D810 with a 16-35mm lens would be perfectly adequate - if you're willing to deal with a 230mm dome.