Resurrecting this thread with a couple more annoying data points.

Hyatt Vivid Grand Island is not available on points for any length of stay other than for a check-in on Monday/Tuesday/Wednesday nights in February 2027. However, it is clear that the base room type is Junior Suite Bay View King Bed, which is available for cash for stays starting on Thursday/Friday/Saturday/Sunday but not points.

Secrets Akumal is even trickier. The base room type available for awards is Junior Suite King, which as far as I can tell it not available for any Thursday/Friday/Saturday in February 2027 - instead, the lowest room category available on those dates is Junior Suite King Tropical View. Looks to me like the base room is a 'fake" category if you will, made up solely to manipulate award availability.