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.
Nikon D5100 Digital SLR Camera with 18-55mm VR Lens - High Resolution 16.2MP
172 Review
Canon PowerShot A480 camera, black
108 Review
Nikon D3100 DSLR Camera with Auto Focus-S Nikkor Zoom Lens (Discontinued by Manufacturer)
109 Review
Canon EOS 60D: 18MP CMOS Digital SLR Camera Body - Your Next Photography Companion
125 Review