For the example above, is the goal to be able to spray upside down? To ensure that the sprayer is able to spray a higher percentage of what's in the bottle? How large is that percentage improvement (90% up to 95%?), what's the incremental cost of increasing that percentage, and what is the actual worth of 5% of the contents of the bottle?
A draw tube that is flexible enough to fold in half, strong enough to not kink, sturdy enough to not collapse when bursts of suction are applied, weighted enough to stay in liquid, strong enough to assemble quickly and easily, etc. is probably also expensive enough to just not be an economical solution.
By the way, if you don't purchase cleaning supplies regularly you may have missed that a lot of those tubes have gone away - they're now molded as part of the bottle so just tipping the bottle will put all remaining liquid at the intake point.
I'm not sure you could actually make it work upside-down without crimping, but at any normal usage angle it works great.
Metal could interact with and damage a lot of different things.
The weighted end will tend to go towards where the liquids are. Imagine a bottle being held lengthwise. The weighted end will be in the same location as where the liquid is.
Turn the bottle upside down... the weighted end drops to where the top of the bottle is, along with where the water is.
Standard pressure thingies still work - you still get a spray. No need for custom membranse.