Been away for a few weeks. Busy in RL...
The technology of the Sigma is currently the closest to film that has been made with digital formats. It has by far the best shoulder and dynamic range that I have seen(one except, which I'll get to below), and truly does look like film.
But the resolution is poor. Literally like APS format if you're looking at film.
Film at a standard 2400DPI scan is ~94 full color dots per mm. This yields roughly 2250X3400 resolution, or about 7.6MP. Note, though, that this is pure resolution. 32 bit color data at each location with no moires or filters or other junk in the way. The best Bayer type patterns barely get 0.7 X in each dimension, which is pretty good, actually, considering what a kludge the original pattern was. This yields roughly 3200*4800 with a Bayer sensor to make 35mm film moot. 15.3MP, give or take. Let's just say 16MP. There are many cameras out now that do this and really DO make film an exercise in futility. Other than the problems with the Bayer pattern and CCD/CMOS/etc sensors.
The best are at about(just under) 0.8, which are a couple that use non Bayer type alignment patterns. The Fuji S5 is a good example. By utilizing a hexagonal pattern. This lowers the number of locations to about 2800*4200. (11.7MP) - this is why the Fuji cameras at 12MP can equal a typical 16MP Canon.
Anyways - the problem is that the Foveon/Sigma sensor has a huge problem. The resolution is like film at 1.0X factor(yay!), but the darn thing only has a 1,768 X 2,652 pixels. Not close to the ~2250*3400 that would be required. So while it looks fantastic, it lacks detail, because it's just not high enough resolution. As a result it creates very "soft" photos.
* I mentioned one other camera earlier that deals with shoulder and dynamic range properly. It's the Fuji S series. It has less moire due to a hexagonal pattern(our eyes don't see the aliasing and moires and defects as easily, much like how a lens with a 9 leaf aperture produces less noticeable starring than say, a 5 or 6 leaf design.
It also has a special mode where it lowers the resolution to about Sigma's but essentially shoots two bracketed shots at the same time and blends them together. This is similar to the "Zero Noise Technique" that is discussed on this forum. It effectively boosts the ratio for the camera to about 0.9X as near as I can tell and adds huge dynamic shoulder as well. The results look stunning to me. As much as I'm a die-hard Sigma fan, the S5 just does better in real life shots where there is difficult lighting or less than storybook outdoor material.(cold rainy day in a forest - no contest between the two)
Note - the S5 isn't *quite* full resolution, just like the Sigma. I'd say it's close in this mode to 90% of 35mm film per pixel. It's sharper than the Sigma by a little bit and most people honestly don't care.
Also, the Fuji software is a LOT easier to use than the Sigma nonsense. And it uses Nikon lenses(huge bonus).
***
Though - let's be honest, neither is a 20MP+ SLR. They both need a higher resolution version of the same design ASAP. Both effectively are like shooting 35mm film with the last 5-6mm on each side cropped off. It's SO close to what we want, but not good enough. And it's been a could of years for both of them. While they've stood still, 16-20MP cameras with the poorer Bayer technology are breeding like rabbits.