In general, I don't think people need to be too brand conscious because basically the flash memory chips inside these memory cards, despite their being close to 50 brands of cards now, are all made by 2-3 manufactures, mainly Korean companies like Samsung and others.
And like any other technology, all of these things fail from time to time. I am yet to find any sort of computer or digital storage technology that is infailable. Given that, I don't think one can say there is a brand of memory cards that never fails. Even Sandisk, which many people praise as being the most reliable, do fail. In fact, the only card I ever had fail on me was made by Sandisk.
At the moment I am employing a mix of brands, Kingston, Transcend and Sandisk, and I am happy to say I have not had any of them fail on me in about the last 5 years. But if they do, there are also programs out there which can sometimes recover pictures from a damaged card.
In my opinion, get the biggest sized card for the lowest price you can and don't worry too much about speed, brand, or failures as none of these issues seem to have any consistency from my experience one way or the other.
If I need to buy another memory card I will simply buy another one of those 2GB Kingston "slow speed" SD cards for 1,070 Baht or a 2GB CF card for 1,490 Baht from Speed Computer (
www.speedcomputer.co.th) as it is the lowest price I have seen at this point in time on cards in Thailand.
If you are in the states you can buy a 4GB CF Transcend card on the internet here for about US$50:
http://www.newegg.com/Product/Product.asp?Item=N82E16820160137Hope that helps.