It is actually totally managable to do 3D-water in Godot. First time I ever did something with building or water or physics in 3D ever, and both the building as well as the water only took about one day to wrap my head around. Sadly I only learned afterwards of a bug in Godot 4.3 that make me loose a few hours on the water shater. I was trying to implement foam at the edges too, but they reversed some rendering mechanics and every example was broken. xD