I remember hearing/reading of Intel using exotic FPGAs to test out designs.
Don't quote me on this but certainly a pointer for further research.
Start here and work your way up:
http://www.dinigroup.com/new/products.php
-- The BIG FPGAs are thousands of dollars and some can get to $10k/each. Products based on these expensive devices are used to prototype ASICs. They are too expensive to deploy in 'products'. A common application, for example, is to use an FPGA Prototype to test head-end cell phone algorithms with real data (CMDA, GSM). The Cadence Palladium pictured above is 10x-100x too slow to do this. Prototyping graphics is very common also.
-- Intel, Qualcomm et al use these big FPGAs. They are a huge customers of Xilinx and Altera.
-- Here is the biggest commercial FPGA card ever built:
http://www.dinigroup.com/new/DN7020k10.php. This card is now obsolete. List price with 20 4SE820 FPGAs was ~$200k. Larger cards have been build by internal teams at several companies. This is hard, very specialized stuff.
-- Algorithmic acceleration using FPGAs, talked about above using Nallatech boards is a 'solution looking for a market'. It turns out that there aren't that many applications that can compete against a grid of GPUs and 4 lines of CUDA. 'C' to FPGA methodologies are a bit silly.
I'd be happy to answer any other questions on FPGAs. The information posted here is refreshingly correct. You'd never believe the conversations I've had with those fools trying to do Bitcoin mining ...