Frank and everyone else-
I think that you're right...and also a little off...with your reasoning.
I'm an artist, not an engineer, so take what I say with a grain of salt.
I needed to back up a hard drive the other day, and in the process wound up clicking around in folders I had forgotten about.
What popped up we're images from different cameras I've owned, or borrowed from friends, or tried out.
Looking back over a longer arc often gives you a fuller, more impartial view over something than the short term, right?
Why I say you're right on track: some of the photos that surprised me the most were from the Nokia 808 Pureview phone. 41 mini megapixels condensed into 7(?) superpixels. It was lousy in low light, but the pics in daylight are still richer, more detailed and have "thicker" colors than my new Samsung with Google Nightsight app. Nokia was on the right path with the efficient Symbian OS, and leading the way in imaging. Too bad they flatlined.
Some of my other (non-Foveon ;-) favorites came from a Sony R1 from 2006, a Kodak dcs 14n that I bought heavily used and got some great shots before I dropped it in the sea, and candids from a friend's Leica M9 that I borrowed for a weekend. What do they have in common? All CCD sensors.
At the time of using those cams I was caught up in the technology of what they did. Now, looking back over 15 years of photos, the artist in me sees the other, more important, story: the tech only serves to capture light. Tonal transitions, fine reflections, color depth, fog, texture, etc
I would have preferred at least the option of CCD full frame with today's tech, despite drawbacks (bad high ISO relative to Bayer, higher cost etc). CCD sensors went the way of Betamax, Nokia folded. I'm holding hopes that Sigma's 3-layer full frame builds a great tradition, whatever happens in phone and computational photography.
Cheers