I love FPGAs. They're awesome for interacting at a low level with just about any kind of hardware, at nano-second-level latency.
But although I bought one, I don't think most people will end up buying one, unfortunately; the vast majority of the consumer stuff that we considered putting on FPGAs in the past (graphics rendering, heavy math) is solved six ways to Sunday by today's GPU. The FPGA also lacks an open-source (or even shared-source) toolchain, there's no way to perform resource sharing, they have code constraints that are physical limits, and so on.
Basically, FPGAs rock when used for chip design or for powering custom prototype or small batch hardware. But they fall into a really narrow portion of the market, because there are few cost-effective consumer-level solutions that make use of FPGAs.
A shame, really. They're super cool.