There aren't that many. Off the top of my head:
Sony F35 - Super35
Sony SRW-9000PL - Super35
Sony Genesis - Super35
Digital Bolex D16 - Super16
Ikonoskop A-Cam dII - Super16
And then you get into 2/3" CCDs, and there are a ton of those. Here's a good place to look for the Sony models. On the Panasonic side, there were the HPX and Varicam bodies. Toshiba, JVC, and Ikegami also had 2/3 CCD cameras, but they were mostly standard definition.
There were a handful of 1/2" CCD camcorders, mostly from Sony as I recall.
1/3" CCD sensors were mostly found in fixed zoom lens cameras like the HVX200, FX1, Z1U, DVX100, Canon XL/XH cameras, and some of the JVC GY cameras. But 1/3 sensors are pretty small.
Compared to today's mirrorless cameras, these cameras were mostly very large and meant to be operated on shoulder or tripods. The smallest and most manageable of the bunch was the Digital Bolex, which now goes for around $7K used.
The Sony F55 is a MOS sensor with global shutter, not a CCD camera.
If you'd like to have a small CCD camera to try out, I'd recommend the diminutive and inexpensive Lumix FZ47 (FZ48 in the UK). It's fixed lens and can't record in 24P or 25P, but it does shoot in 1080P and the 1/2.3" sensor is larger than any of the 1/3" cameras. And the image stabilization is surprisingly good, which is useful for the ~600mm equivalent zoom. Here's some footage I shot:
I personally love the camera, but I wouldn't say that the grain is good at all. If you freeze-frame the footage, you'll see a ton of temporal ghosting and macroblocking. But in motion, it's one of my favorites.
And here are some of my photos with it (JPEG only, the camera does not shoot RAW): https://distanceandelevation.com/blog/2021/8/9/bandontoportorford