Mike:
Type I or II shouldn't be an issue as per other posts. Most current cameras using CF cards support both. Among the 'basic' cards, there is little (imperceptable) difference in speed /performance.
However, the are some cards with higher write speeds which better support some cameras. In cameras, 5 Megapixel and above, when you shoot a high speed burst of shots (like a motor drive), It's desirable for the card to write the files fast, flush the camera's memory buffer and be ready to accept another burst. For this purpose, I believe the high end cards are worth the extra investment.
There are other brands and model names around (they escape escape me now), but I've been using the SanDisk Ultra II 1 Mbyte cards. They write any file noticably faster than "basic" cards I own. By basic, I'm referring the $49 256 Mbyte cards you can buy at Target / Sam's Club, etc.
Here's a link to an article that might help explain.
<
http://www.dpreview.com/articles/mediacompare/>