Is duct tape the best quick fix for a leak in a waterbed?

No, Duct Tape isn't a fix all, while it will help for small puncture holes. However, duct type will not fix a rip because the rip will increase in size with pressure. In this case you should just get a new matress.