I bought three Phillips SPC 900 NC webcams because they claim to support up to 90fps and I have had good luck using linux with the PWC drivers in the past. Plugged into a generic Ubuntu 7.10 install, I found that 640×480 resolution was automatic, with 15fps. 320×240 worked at 30fps. (I tried 160×120 resolution, but wasn't able to get a speed faster than 26fps with that, so I'm doubtful of the 90fps claim from Phillips, at least with the stock Ubuntu drivers.)
This useful website looks to provide nice OpenCV support for this camera.
I have also archived the relevant files on my site, in case the above link goes down.