A good patio umbrella tilts with one hand, locks without a fight, and throws enough shade that you can actually read a book at two in the afternoon instead of squinting at it through sunglasses. The fabric should feel tighter than a bedsheet when it's up, not flapping around like a sail, and the pole shouldn't wobble every time the wind picks up. Sit under a cheap one for an afternoon and you'll know the difference immediately, because you'll spend the whole time adjusting it instead of sitting still.
These suit almost any outdoor space that gets real sun, which is most of them from May through September, but where you live changes what matters. A small apartment balcony wants something that tilts or cranks easily and doesn't need a base the size of a coffee table, since you're probably working with a few square feet and a railing. A backyard patio with a dining set wants a center pole umbrella that can handle real wind, because nothing ruins a dinner outside faster than chasing a canopy across the lawn. Morning coffee spots want something that can angle low, since the sun comes in sideways early and late in the day and straight overhead at noon, and a fixed umbrella only solves one of those problems. In a rented place, a weighted base you can move is worth more than a bolted in pole you'll never get your deposit back on. As for what it sits near, plain canvas colors work better than patterns in small spaces, since a loud umbrella over a small table can make the whole patio feel like it's trying too hard, and a simple umbrella stand or base in a neutral stone or black tends to disappear under whatever else is already out there, a side table, a couple of chairs, a planter that's seen better days. If you're starting from nothing, go with a market style umbrella on a weighted base rather than a built in table umbrella, since it works over a dining table now and can move to a lounge chair or the corner of the yard later, which a hole drilled through your table cannot do.
The ones worth living with are the ones you stop thinking about, the shade just shows up when the sun does and the thing closes without jamming halfway. I'd rather have one solid umbrella I open every weekend than three cheap ones stacked in the garage because none of them quite worked. Somewhere between a lazy Sunday and a dinner that runs past sunset, you'll notice it's just there, doing its one job quietly, and that's really all you want from it.