I have used Sika Flex and 4200, the former is cheaper but West Marine doesn`t carry it here in Maine.
Any polysulfide compound should work. Cleans up well, lasts, and is removable without cutting a hole in the deck, for the next time you have to take off the stanchions.