I for one am SUPER excited by the SD1. For years, Foveon has failed to keep up in the megapixel race. Yes, they have more color resolution (chroma data), but lagged way behind in image resolution (luma data). With the 3x15.4MP sensor, the slight loss of luma data is EASILY outweighed by the HUGE jump in true, uninterpolated chroma data.
The 5D Mark II, for example, is a 5.3 MP Red-Blue, 10.7 MP Green, 21.3MP B&W camera. Sadly, because the 5D is full-frame, has awesome high-ISO performance, and does video, I can't get rid of it when the SD1 comes out.
The big questions for me are: 1) how is the quality of each pixel's red, blue, and green channels? 2) how is the high-ISO performance? and 3) what FPS and how good is the autofocus? I was seriously considering a 7D as my walkaround camera because of its high FPS and the Canon 15-55 f/2.8 IS, but the SD1 just might be calling my name.