Espresso machines can be a great investment if you're a true coffee aficionado and like to experiment with different brews and recipes. It can be a fun and tasty hobby, almost like a science experiment, but they can be quite pricey and may take up valuable bench space in the kitchen.
Since you mentioned that you already have a cafe downstairs, and depending on how often you drink coffee, it might be more convenient (and cost-effective) to just stick with your current go-to.
However, if you're a real coffee lover and enjoy the idea of having many different options right in your kitchen, an espresso machine could be a fun addition. There are also cheaper options available on the market, or you can often find good second-hand deals!
Perhaps it's worth trying out coffee made with an espresso machine before committing? See if your coffee-lover friends have one and try theirs to see if the taste ticks all your boxes.