Stand choice has to do with two things.
Max height
Footprint
Height above crowd in a large venue is a good thing.
When running in a crowded club a small footprint is important.
Also consider clamps and extension poles. Often hanging mics in a small club gives better results with less trip hazards.
So really, the answer is, "Depends"
I have a 13 foot stand for outdoors, a 6 foot round base stand for tables, 2 short stands for onstage taping, and a set of Superclamps, the Manfrotto 099b and assorted other gack that I'll pull out when the gig warrants it.