My understanding is that the negative Covid test is required for Americans staying on the French side. Canadians arriving on the island directly from Canada are exempt, since under the French rules Canada is on the list of "green" countries. The USA is still on the "orange" list, hence fully-vaccinated Americans still also need the Covid test to stay. Again, none of this is applicable if you are staying on the Dutch side.