Like most questions around here....it depends.
There are many types & sizes of light stands...some are cheap, other are expensive but most importantly, some will work best for you personal situation.
For example, a big heavy stand will likely be more stable, which is always a good thing...but if you travel with your stand, or use it on-location, then a smaller size & weight may be more important to you. If you are just going to use it in-studio, then you may want a heavy stand...but some photographers are constantly moving their stands around so maybe not. Also, how much space do you have to work with? Big sturdy stands will have a larger footprint, which takes up space and creates more of a tripping hazard. Maybe a stand on coaster would work for you?
How much weight do you have to hold? Flash units don't weigh much, but studio strobes run the gamut from light to quite heavy. For heavy gear (or just for safety at all times) air-cushioned stands are great. That way, if the stand collapses suddenly, the light is cushioned.
You will pay a bit of a premium for a good brand name like Manfrotto...but they are a good brand, and most of their stuff is very high quality. Of course, if you just want/need something cheap...there are many other brands like Impact, that sell at more reasonable prices.