Only the Foveon concept isn't particularly good
The colour filters on a bayer sensor can be designed to replicate the colour response of the human eye, in which there is a large amount of overlap between red and green. A Foveon sensor can't do this because of the way it separates the colour. Imagine a monochromatic orange light. A bayer sensor will pick some up in each of the red and green channels, which will tell the camera that it's recording orange. A Foveon sensor will record it in either the red channel or the green channel, depending on the wavelength, and can't know that it's all gone wrong. It's like a 3CCD, and those are going out of fashion too.
Additionally, despite the marketing material that suggests that Foveon records red/green/blue in its three layers, it's actually recording white in the top layer, yellow in the middle and red in the bottom. It then introduces large amounts of noise as it performs the maths required to turn this back in to red/green/blue.
And that's completely ignoring the complete dishonesty in marketing it as a "46MP" camera.
You probably don't actually want Foveon, although Sigma does make some good lenses.