There isn’t much there
Lavonicus over on Reddit has done a great civic duty for allFallout 4players — he spent over 30 hours exploring the depths of every major body of water in the game. The experiment was mostly fruitless though, because outside of a hint of a possible DLC bit, there isn’t much there to find. Now you don’t have to do it though!
You can readthe full 113-image post, and the map below highlights the more interesting parts if you want to check them out for yourself.
100ish% of Fallout 4 Underwater Explored (113 pictures and 2 Maps)[Reddit]