It sounds like you are asking yourself the right questions.
A couple other things to think about, do you want a lake view?
Marina? Do they allow boat lifts?
Winter access?
Water, sewer, garbage? Probably included but I’d want to ask to make sure.
We went through a similar decision about two years ago. Was probably about the same point in life too, 15 years from retirement. Wanted multi-species water. Love Vermilion and been on it many times but it was not a drive I wanted to make every weekend from the south metro. Decided on the south side of Mille Lacs. From the south metro we can usually be there in less than two hours depending on traffic.
Also, with Mille Lacs there are lots of smaller waters to the west and north that offer other options.
Another option is to look south. I have a co-worker that leases on a lake north of Faribault and they only have a one hour drive, the opposite direction of most Friday afternoon traffic. There are a lot of lakes down there with walleye, pan fish, pike, and musky, but not necessarily on the same lake. Might have to trailer the boat five minutes one direction or another to pick the species you are looking for that day.
As mentioned, upkeep is the big trade off between owning and leasing. We own and have to be around to mow weekly, and clean up leaves in the fall. Luckily we worked a deal with our neighbor to trade off mowing. So now we only mow every other week but twice as much to mow when it’s my turn. Leasers in the same park have no yard work to do but they pay twice as much each year for that luxury.
In a resort you can be packed into close quarters and you will get to know many of your neighbors, even in a 40′ by 100′ lot. It would be a plus to meet them prior to deciding. I don’t know that I could sign something this time of year having not met a few neighbors first.