It may seem backwards, but you may want to determine what you want to do with the boat, and how many of the family and friends will want to go with you, and for how long, before you start narrowing your range of possible boat types and makes.
I would guess that some of your kids have kids of their own, as well, which makes the superyacht in the GIF above a reasonable idea for a family gathering on the boat for more than a few hours at a time.
It is likely that no boat will satisfy all of your needs, wants, and desires, so sorting your ideas this way may help direct your search.
Yachtworld is a great resource, as is Boat Search 101 on this forum. I found that other sites have had more of the mid to lower priced boats, but as many here have said, pay me now, or pay me later.
Older boats at lower (not low) price points may need expensive work to bring them up to par.
You may want to spend the years until you retire learning the mechanical, electrical, and seamanship skills you may need to be safe and comfortable aboard while cruising.
Chartering likely boats for a weeks vacation can be very helpful in learning more about what you need and want in a boat.
When we searched for out boat, we found the lower priced boats on sites like boats.com, boattrader.com, iboats.com, and Craigslist in boat-heavy cities.
We took road trips to see boats which interested us, to learn the difference between the pictures and the reality and useability of those boats.
Things like engine room size and access, doors, headroom, shower size, kitchen layouts, and boats where I just could not get to the places I would need to be to operate the boat. (Big feet and narrow side decks = no.)
Good luck, JohnS, Cheoy Lee 40 LRC