I am just going to note the most hard and long lasting and then to the softer least lasting. Keep in mind that the hardest ones often are the most costly and difficult to work with as well.

Marine Epoxy - Expensive and hard to work with requires a long time to completely cure (1 week +) but cured is food safe and close to 100% water proof and exceptionally hard.

Liner Polyurethane (two parts) A catalysed paint that when mixes it is going to go solid no matter what. It also is expensive and hard to work with but cures to a non toxic finish (PU plastic similar to PU tubs) and is very hard wearing and water resistance is very high (below the waterline safe it is boat paint)

Polyurethane (one part) these are the best oil based paints usually are pre mixed colours so there is little choice the are a little hard to deal with but are a basic oil paint they need 24-48 hours to dry to out gas and ideally in a well ventilated warm place. They are resistant to water and fairly tough at a reasonable price. ( like varithane colors in plastic)

Alkyd enamels basic oil paint this is a bit debatable as some of the modified acrylic paints are very good now. Basic oil paint the same to use as poly paints and IMO not worth the effort either go up or down.

modified alkyd latex paint This is a latex water based paint with modified alkyd components. They are somewhat hard wearing and splash resistant.

Latex paints are easy to use the lest hard and moisture proof.

All paints require a dry time so but sure you give it enough and avoid speciality paints designed to be mould or mildew resistant (insect proof too)