As for the old fashioned pitcher pumps, I bought an antique on the bay. The new ones are made in China and are...
I took mine apart (easy) and made new leather gaskets for it (easy) and lubed it and it works great.
Max pull on those is advertised as 30' but they won't do it. Maybe they would if everything was perfect but there is some loss in the usage. 25' is more like it. As others have said, that's to your actual water depth, not the well depth.
For up to 50', I really like the PVC single foot valve pump. Deeper and you need the more complex by very doable double valve pump.
Simple single. It will be moving straight up and down and you can put a T on it, cap one side and make a spout on the other: