Those are probably for OEM, machine vision and various custom applications. If you notice, they don't list spec's on connectivity like Ethernet or even USB ports we are used to. They're the basic imaging components for whoever else to attach their own housing and connectivity hardware options.
It depends on what you mean by the term "cube camera". While the vast majority fit into your description, there are/were some that don't. Two examples: the dicontinued Sanyo cubes, which were very popular with casinos, and the Ikegami ICD-505 and ICD-525, which we used in low light areas because their AGC didn't introduce as much distortion in the video as other cameras.
The strongest selling point of those cameras was their ability to fit inside Pelco DF5 back boxes. Recently, we have found better alternatives such as the inMotion and Vitek mini box cameras.
The Sony camera blocks, as well as their Hitachi sisters, are actually camera modules from consumer camcorders. For CCTV, they are used in many PTZs, including Pelco Spectras, AD and others. They can be found as repair parts at TLS Electronics / Time Lapse Supply.
Gotta love the white lens. That was one of my complaints about the Ikegamis - lack of color options. We took pains to order smoked domes for the DF5s we installed in lower ceilings, then Ikegami makes their cameras stand out like sore thumbs, even with smoked domes.
I'm surprised this didn't show up on the survey as a major negative of cube cameras - the fixed field of view of most of them. Even in a low-end SOHO environment that limitation keeps them crossed off my list in nearly all cases.
By the way, Panasonic and JVC also used to make camera modules but discontinued them years ago. We had a number of AD Cobra Domes when I started here that used Panasonic modules. I've also heard rumours that Hitachi is discontinuing or has discontinued their modules, leaving Sony the sole supplier.
Interesting tidbit: the original Pelco color/monochrome day-night Spectra II BCBW used a Sony camera module. These had major problems in casino environments - the flashing lights of slot machines caused them to lose focus; which could sometimes be cured by cycling power but other times required camera module replacement.
I was talking to a Pelco engineer (something they used to allow if L1 and L2 Tech Support couldn't resolve an issue) who told me Sony admitted there was an unrepairable problem with the modules' "fuzzy logic auto-focus circuit" but that Sony refused to replace the defective modules. Around that time, Pelco switched module suppliers to Hitachi for at least their day-night dome drives.
I believe Pelco has switched back to Sony for the vast majority of their PTZ domes. Possibly due to them being the only manufacturer left?
And yes, the modules are not suitable for normal CCTV use. They require a lot of external circuitry, including power supplies and computerized control interfaces.