The weather is nice year round in my vacation destination area. There are attractions and restaurants within walking distance, so home is all staycation all the time now that DH and I retired.
I haven't tried it, but some local hotels offer day passes so locals can enjoy their amenities like pools, spas, gyms and sports facilities.
To me, a special staycation is staying at a lodging within the county.
About 20 years ago at a NYC conference, I won a raffle prize of weekend at a beach resort just 15 miles from home across the bay. Convenient, since the prize didn't include transportation to the destination!
More recently I've been gifted week-long staycations at an inland golf timeshare resort in the hills about 40 miles away. This was a great home base for early morning trips to the safari park (zoo member so no entrance or parking fee) for the upsell-but-totally-worth-it behind-the-scenes safari tours, or for mountain driving adventures.
I enjoyed these "free" staycations but not enough to seek out other local lodgings to staycation. We renovated 10 years ago, home is way more comfortable with no garage parking fees!