I'd say that metameric failures are not that common with modern cameras. What you get is that in certain ranges the color filters are worse at separating colors (meaning the profile needs to "stretch" more in that area leading to more noise), but as filters are overlapping they can separate at least some. Sure, with some narrow band artifical color you can trigger metamerism, but it's a narrow case.
Commercial profiles generally prioritize robustness over a specific look design, and thus the profile's stretching is quite weak and thus closer to a linear matrix profile, and thus more of the sensor's color filter character is kept. If you wish you can force cameras to look very similar, but it will lead to quite aggressive stretches and a less robust profile. Still, even if you relax the stretching a fair amount modern camera color filters are today so similar that the looks become very similar anyway.
Between Kodak and Dalsa CCDs there was a big difference between color filters. Between various modern CMOSes today, not so much, unless you look at extremely saturated colors and narrow band colors. The Dalsa CCDs have color filters that are "modern" and neutral, while Kodak seems to have tried to mimic a subjective film response.
From my profile work I've noted that "pleasing skin tones" is not so much about hue or color separation, but how contrast is applied (the eye/brain's color perception is modulated with contrast) and how you rolloff to the whitepoint (highlight rendering). This is about profile and raw converter design more than anything else. When designing those aspects you have very little color science to rely on so it's very much an art.
I don't totally dismiss that CCD could have some different look aspect than CMOS, but suspect if so that it's a pixel peep effect, a texture difference due to sharper aliasing, a different noise quality, and less if anything about color. Sure if everyone loved the Kodaks which indeed have much different color filters, but Dalsa with the more neutral/modern and similar to modern CMOS filters receives much more love. In any case in my work I haven't found the CCD vs CMOS difference to be worth any specific attention.