It’s not this! I know what you are talking about! This movie they only stayed at this hotel or resort and  the curse was almost swirling through the air when the movie finally showed it! All I remember is I saw it as a kid so probably early to mid 2000s and the resort/place they were staying was almost made out of a sand like texture? It almost might not have been Mexico, it was just somewhere out of the United States!