Who needs it? anyone who needs a backup camera with a large DSLR. It has the perfect depth for a good landscape camera. As others have said, it's terrible in low light, longer exposure times, poor battery life, poor playback time of a freshly captured image. Sigma even offers an extra battery for weak battery life. A fast SD card doesn't seem to help. This may be because each of the files is huge and the Foveon sensor does a lot of on-camera processing; TIFF is typically around 100MB (a rough approximation of the clarity obtained compared to 20-30MB of 5D mk3 RAW). But there is a downside, the images you get from this camera are too sharp and almost 3D. It often even outshines my 5D mk3 with an L lens. The image quality (details I would say) with the Sigma is amazing: I feel like a detective in a CSI episode as I can zoom almost indefinitely :) The software that comes with the camera is not good. The best post-processing option is to export to 16-bit TIFF and use Lightroom. Finally, try one of these. I think this may or may not be your cup of tea.
Discontinued Canon EOS 7D Digital SLR π· Camera Body Only with 18 MP CMOS Sensor
88 Review
Nikon COOLPIX L810 Digital Camera: 16.1MP, 26x Zoom, NIKKOR ED Glass Lens, 3-inch LCD (Blue)
95 Review
Nikon D3100 DSLR Camera Body (Kit Box) - No Lens Included, International Version with No Warranty
298 Review
Canon EOS 60D: 18MP CMOS Digital SLR Camera Body - Your Next Photography Companion
125 Review