I dunno man, I've seen that all of the consumer and consumer-leaning prosumer HDV cams aren't in any of the stores, but B&H has a shitload of them, and they seem to increase in number the higher up you go towards professional-grade. Kind've like Beta... consumers got suckered into using VHS because of Sony marketing magic, yet Beta is still used in the industry side regularly.
You're right on though... there's a Best Buy right by my house and they don't have any HD cams that use tape. I wouldn't want to use anything else... hell, even if the cam stops recording correctly I could still convert it over as a tape backup for data!
Sony had shite all to do with VHS, which was backed by JVC. VHS won that format war because porn was allowed to be readily available on VHS and that there were more films available for rent on VHS. Beta was the better, more reliable format which is why it's still the industry standard, allbeit in digital form these days. Similarly, Sony were opposed to porn being available via BluRay, but when HD DVD (which was itself a better format) entered the battle, making porn available this time round became a no-brainer for Sony- basically any camera, format, medium, technique, etc. which the porn industry adopts is bound to be king.
As I see it, the thing with the over-abuse of slow-mo HD in recent years for me is simply down to chaps trying to stretch out a day's worth of footage to fill 3 minutes, hence the tedious cliched shots of homie setting up a board in slow-mo, eating in slow-mo, laughing in slow-mo, etc. Recent radness like Dylan Rieder's Gravis part, any of the recent Cliche ads or Hold Tight Henry's work in the past 2 years doesn't suffer by virtue of what they're shot on. Ultimately, any video guy who knows what he's doing will produce good footage, whether it's VHS-C, Super 8, Red or Imax. If you don't have the eye for it, you're fucked.
Just my extra nerdy 2c worth...