I don't personally have one but have seen them on boats.
Assuming you get the correct one for the OD of the pipe you are attaching it, I'm sure it work well.
The only thing I would investigate is the set screw that locks it in place. It appears to be at the base of the holder on the clamp.
From the picture I've seen, it looks like this set screw bites into the piping under the clamp. to keep it from rotating when pressure is applied.
My concern is for the pipe under the clamp and will this cause you any problems.
The alternative is to put a hard mounted on through the hard top. I think, I'd be inclined to do with the clamp on myself.
tx