"Lumbar support" is shorthand for several different mechanisms doing different jobs that define what an ergonomic office chair really is. Get the wrong one and the chair will frustrate you regardless of price. Get the right one and a $300 chair can outperform a $1,500 one.
Static contoured back.
A fixed lumbar curve molded into the backrest. Cheap, simple, fits a narrow band of bodies. Good for users between 5'7" and 5'11" with average spinal curvature.
Adjustable-height lumbar.
Slides up and down. The most common adjustable system, and the one most users actually need.
Adjustable depth + height.
Two-axis adjustment. Worth the upcharge if you're outside the average range - very tall, very short, or have a known spinal curvature.