That is kind of like asking for suggestions on what kind of car to buy for someone that drives

HUGE Price range. The really smooth video you see uses a gimbal and this adds to that price. So it really depends on what the goal is. If its just pictures, then a gimbal isn't needed. But if you want smooth video, it is.

I have two - a DJI phantom and splash drone. The splash drone is water proof with a water proof gimbal. I chose the splash drone because its water proof - even the gimbal and I had lost a prior phantom due to crashing in the ocean so I wanted something that could survive a dip in the ocean.

Lots of other options and a wide price range. I'd say if the goal is a lot of shots over/around water, then a water proof drone would be a good option.