Automatic wand, manual wand, or carafe
A manual wand gives you the highest ceiling and a learning curve measured in weeks. An automatic wand texturing to a set temperature gets you most of the way there immediately, and some can be switched to manual later, which is the best of both. A carafe system pulls milk through a tube and delivers a finished drink: the lowest effort, the lowest ceiling, and the most cleaning discipline required.
Steam power is why café milk feels different
Home machines with a single boiler share heat between brewing and steaming, so the steam is softer and texturing takes longer, which gives bubbles time to form. A dedicated steam boiler or a machine that heats fast enough to switch without waiting is what produces that dense, glossy microfoam. It is also the main thing you pay for as you go up in price.
The milk path is the maintenance
Count the parts. A two-piece carafe that goes in the dishwasher gets rinsed every day; a system with internal tubes and a cleaning cycle gets skipped, and skipped milk systems turn sour and eventually block. If you are choosing between two automatic machines, pick the one whose milk path comes apart in your hand in under a minute.
Milk temperature is where home drinks go wrong
Overheated milk tastes thin and faintly of cardboard because the sugars break down, and most beginners overheat by a wide margin. Anything that ends texturing at a set temperature, automatically, fixes the single most common fault in home milk drinks. If you are texturing manually, a cheap stick-on thermometer teaches you the feel faster than anything else.
Match the pitcher to the drink
A pitcher much larger than the drink gives you a pool of foam you cannot control, and one too small overflows while you are still stretching. One pitcher sized for your usual cup will improve your milk more than the next machine up will, and it costs almost nothing.