Great suggestion from a previous poster to try chartering before spending big $$ before you're ready. Lots to learn, at little risk.
Regarding the "which boat should I buy" issue (not sure why you'd give a fig what my opinion is here), I'm sure you realise all boats are a compromise. They can be fast, cheap, or good. Pick two. NO boat will fulfill each and every one of your criteria for ownership. As an experienced sailor, I expect that's not news to you.
Many contributors on this forum immediately pile on the fuel burn issue of various engine/boat/hull/speed design topics. And I sense you are in that camp. But my experience after a lifetime of sailing, and operating of multiple power boats as well, is that the fuel burn is a minor fraction of the overall cost of ownership of ANY boat. For example, one of my previous boats was a 53' Canoe Cove aft cabin motoryacht. I saw 18 knots on sea trial, seldom operated above 10 knots, and averaged 8.9 gph over my 13 years and 2000 hours of ownership. Which was a whopping 8% of my cost of owning this beast. My current boat operates on 3.7 gph at 8.5 knots. Wanna save on fuel? Slow down.
Regarding coastal voyaging, most all of the common boats discussed on this forum (35'-60' moderate-speed "trawlers") are perfectly capable of passages of 125 nm in a day, should the skipper and crew be up to the task. Operation in open sea with typical 8-10 foot long-period swells is routine, and only complicated when they are on the beam, and/or topped with short-period wind-generated chop. Given stout crew, most of the production boats discussed endlessly on this forum perform just fine "at sea". Not so much the crews, but that's strictly a personal matter.
Again, for example, my Canoe Cove was routinely operated offshore along the Pacific Coast for days at a time, 24/7. Tough sledding sometimes, but not an issue for the boat. My current Pacific Trawler is equally comfortable at sea in 8-10' seas, but not so much with a 4' wind chop to boot. But my old bones are warm and dry in my pilothouse, so if it's nasty, I either stay home, alter course to maximize comfort, or turn around should my crew and I decide enough is enough.
Lastly, don't forget that 8-9 knots dead upwind inside a warm, dry pilothouse (easy-peasy most of the time) covers a ton more ground than 6.5 knots in the open cockpit of any sailboat. And this comes from literally years of doing both.