The last D-SLR with a Foveon chip was the Sigma SD10, announced two years ago. The previous SD9 was announced a year earlier (late 2002). I don't know what's slowing down the release of a successor, but maybe Foveon is having trouble fabbing their chips. I'd imagine it's far easier to fabricate the Bayer-pattern sensors. So long as the resulting image is beautiful, do you really care how it got that way?

Sigma got some kind of exclusive deal with Foveon. If and when Sigma announces a newer body using a standard CCD or CMOS sensor, that will tell you pretty everything you need to know about Foveon's future.