Where will the spent grounds go...? Now you have something that is not a simple problem and will not have a simple solution. In fact, it is a $15K solution
https://www.seattlecoffeegear.com/rancilio-egro-one-pure-cof...
Say what you will about Nestle, but they seem to be the only people trying to make a decent cup of coffee easy to serve.
Update: thanks for the downvote. I will stop attempting to show you how the expectations you have for a cheap, carefree coffee machine are unreasonable unless you make some compromises or invent it yourself. It is an unsolved problem, but I get the message. I am not welcome to burst your bubble with the real cost of things.