I have a Manfrotto 516 videohead plus a Manfrotto 161MK2B tripod for interactive use plus a number of smaller Manfrotto tripods for static cameras. I have not compared this against other models so I cannot say if it is "best", but, it has worked for me when needed. However, I dive mainly in waters that either have silty bottoms/ship decks or virtually no bottoms at all. Thus it is quite rare for me to haul this big rig with me. Considering the silt I cannot let my fin touch the bottom or ship deck. Consequently the fluid drag of the video head has to be set at a small value to enable panning/tilting the head whilst you are floating behind it.
Due to the above, I prefer to take a small tripod with me for opportunistic dives. The small tripod gives slightly more weight and inertia even when using the camera whilst swimming freely in water. Please notice that the TLC T/S head does not have dampening fluid in it and it is meant to be mounted on arms with 1" balls, i.e. not on a regular topside tripod.
Only for carefully preplanned shots would I consider to take a proper video tripod with me. The sea water here is far less salty than in the Atlantic, so rinsing with fresh water has been sufficient and I have not bothered to check the inside of the head.