Amen to the OP, its like looking for an honest politician trying to find a presta valve stem shorter than 42mm now. They just seem tacky on a square section tubular or clincher rim to me. I would be happy just to find some decent 38mm or 36mm presta stem tubs.

And even in a tube for clinchers they are getting scarcer and scarcer, my CAAD 10 has a shallower aero section to them and the 42mm are well above the top.

I have not been in a Walmart in many years now. Had no idea that they had them, are they Bell?

Bill