In shopping for a new digital camera, I see a variety of storage media. What's the best? Why? What are the pros and cons of the more popular media? Seems like Compact Flash and SD/MMC are the most common - are these the best?

Thanks for any input!