I think for a large part of the population, COVID is "over".
This is definitely true. Just look at the posts here, it's over for many of them too. Some because it really is mostly over for their geographic area, barring influx from other areas. Others because they're completely vaccinated and don't have any loved ones still left out of the vaccine pool.
The only people it's not over for are those with loved ones that are not eligible for vaccination yet (parents of kids under 12) and those who the vaccine will not work for. With a larger focus on those in areas that haven't gotten it under control through everyone else vaccinating.
There is a segment of the population who still believes the vaccine is riskier then the virus.
It's over for these people too. Perhaps more accurately, it never started for these people. The vaccine is riskier partly because they feel COVID isn't a risk at all.
Way back, I predicted that it would be over when we got deaths under 150 daily for the county, roughly 55,000 a year (and I felt bad for this). July 4th is messing with the 7 day average, but we were at 200, 73,000, on 7/1 and once we get beyond the holiday, I think we'll be at 175, roughly 64,000.
As a county, we apparently don't travel as much as I imagined. That distribution isn't even. While the country may be at a 175 rate, many areas are contributing almost nothing to it. What's going on in MO for example isn't pushing out to many other areas. It's still going to be an issue for travel destinations, as those destination lag or have many travelers from uncontrolled areas. At least until everyone is able to vaccinate.
I know for us, I'll be much more willing to travel to a questionable area once the entire family is vaccinated. Probably still not to an actual hotspot. While currently not all are vaccinated, we planned travel based on outdoor, distance, or low spread in the area. I would put FL in the questionable not hotspot category right now.