First thing is that you want to think about at least five nights somewhere. When you book a 5-night standard award, you only pay for 4. So a hotel that costs, say, 90,000 points/night would only be
4 x 90,000 or 360,000 for
5nights.
Second, the world is big, ya' know

Where are you based and how much time/money are you prepared to spend in transit? Hard to make meaningful suggestions otherwise.
Third, the most expensive properties tend to be hard to book at standard rates. The Waldorf Pedregal in Cabo San Lucas is pretty amazing...but good luck finding five nights at the standard rate of 120,000/night. You'd have to be very, very flexible and check the website daily to have a shot at booking this. Of course, you could book any time at the premium rates of 500,000-1,200,000 points a night (with no 5th night free), but that's a
lot of points.
All this is to say, we need more info.