I've been using the same trio of Camelbak Podium Big Chill water bottles since I got into cycling. They've been frozen, dropped, dropped and run over, left in the trunk with an inch of Gatorade in them for 3 days, and they still work just fine. I don't need to be able to see through them because my brain still works well enough to remember what I put in. They're water bottles, not cruise missiles, so the level of sophistication required of them is pretty low. Oh, and I freeze my bottles without lids on them, because I don't live on a boat, and have little worries of the liquid flying around while the bottle stands in the freezer.
The OP's list of demands is to me a bit daft, as it can be easily satisfied by just throwing money at it, as most things can. If $20 a pop is too much, then you're in the wrong business.
Lastly, if you find a bottle you can squeeze while it's frozen solid, good job, Hercules.
__________________