I have used a VBM Piccolo and I can vouch for its ability to produce marvellous coffee. The downside of the single boiler dual purpose is that they cant steam milk and pour shots simultaneously, not a big issue if you are only ever preparing for one or two people. Another downside is the need to take care with the boiler, it doesnt autofill and you would have trouble steaming more than one 600ml jugs worth at a time before needing to prime the boiler again.
This is true for all single boiler dual purpose machines. The Lelit might suit your needs and I will leave it to those who know more about this machine to critique it in comparison to more powerful machines like the VBM, Zaffiro or Diadema Perfetta
There is a second-hand one, not that much used, still for sale from a Newcastle snob and includes a grinder. You have figured in a grinder havent you?
You say cafes meet your current needs but your needs can change and, if you suddenly find drinking coffee at home more pleasurable than you anticipated, you might regret not going for something with greater capacity.