There are a couple of SDIO cameras. Have a look at
www.veo.com and
www.lifeview.com for their cameras.
The Veo Pocket Traveler is cheaper but only works at 640 by 480. The Flycam by Lifeview is a 1.3 MP cam.
I am trying to get some review samples for a Pocket PC Thoughts review. If I can get review samples you'll see a review in the not that distant future.
PS Just chnaged the flyview address with lifeview - sorry for the mistake
Regards