I have seen some people work on a Kodak sensor and also Cine Pi's latest work with the IMX585 sensor is really amazing (4K/8K upscaled). The IMX585 sensor is expensive though compared to the HQ Cam IMX477. Here I'm using the Pi Zero 2 here so can't do 4K I believe (data lanes limit or something, also writing to SD card).
Thanks for the link to the Kodak sensor - that's awesome, because those sensors have a fairly common interface across all the other Kodak sensors like the 48x36mm Medium format 22MP sensors... It would be pretty easy to adapt this project to make your own CCD medium format camera!
Breaking Taps had a video not long ago covering his efforts to design and fab his own image sensor, though it didn't work and it wouldn't have been anywhere near 1MP even if it had.
Kodak sensor https://www.youtube.com/watch?v=Ma9FrN5COIo
Recent CinePi work https://youtu.be/tI7hIKG1v40?si=BUvOOGutQJDnv09q&t=177
I'm not affiliated with CinePi I'm just amazed what you can do when you know what you're doing ha (eg. color grading)