I've found these superautomatic espresso/coffee machines fascinating ever since I frequented our group's HQ in Erbenheim, Germany when I was working. Espresso, double shots, cappuccino if desired...all with the press of a button. That one in our office was a commercial machine with a direct water supply, inline filter, etc...
A few years ago, Tchibo, a German coffee company, came out with a residential market version.
Limited-time deal: Tchibo Single Serve Coffee Maker - Automatic Espresso Coffee Machine - Built-in Grinder, No Coffee Pods Needed - Comes with 2 x 17.6 Ounce Bags of Whole Beans
https://www.amazon.com/dp/B0BZTJQQTT?tag=tvwb-20
It goes on sale frequently for $300.
In researching further, I found this from Whole Latte Love:
The compact Gaggia Brera in Black was designed with user convenience in mind. This programmable bean to cup machine delivers perfect espresso every time.
Save on a Refurbished Gaggia Silver Brera Espresso Machine. Further proof that good things come in small packages, the Gaggia Brera is a fully equipped super-automatic espresso machine with a compact footprint that will leave you with plenty of counter space. The Italian-made Brera has been...
www.wholelattelove.com
It is $300 for a refurbished and the reviews for the refurbished ones are excellent overall. They are $450 new.
This would sit on the counter of our beach house kitchen where we have a bit of counter space.
I know these machines do not like oily beans so I'd be getting coffee from somewhere besides Costco...although I think the Mayorga Cubano roast Costco carries could be just fine but we're close to several places I can get whole bean coffee from so that's not a concern.
I just ordered the Gaggia Brera silver. $317 delivered. Should be here by the end of the week.