There are two primary differnces between SD cards:
1. Read/Write speed.
2. Quality of microchip.
The first thing that needs to be said is that digital photographs are, well, digital. They are stored as a series of 1's and 0's on the disk. A 1 is exactly the same on one disk as it is on any other, and a 0 is exactly the same on one disk as it is on any other. In other words there is absolutly NO difference in image quality on an expensive disk as there is on a cheap one.
Now, to get into the difference. The biggest difference is the Read/Write speed. SD Cards come in 3 (soon to be 4) classes, class 2, 4, and 6. Class 2o cards write at 2MB/second, class 4 @ 4MB/sec, class 6 at 6MB/sec...all of which are minimum speeds. These speeds are defined by the SD Association.... but are not verified by any governing body. This means, its is possible to buy a cheap card maufactured by some generic factor in China labled as a Class 6, but it is only a class 2. It should also be noted that you may find some SD cards advertise a "maximum speed"... but you should ignore this as that speed is pretty much impossible to obtain under normal operation.
What this means to you.... First lets look at the photo's you are taking.
8 megapizel photo in RAW12 = 12MB, JPG100 = 1.9MB
6 megapixel photo in RAW12 = 9MB, JPG100 = 1.6 MB
4 megapixel photo in RAW12 = 6MB, JPG100 = 1.2 MB
If you are shooting an 8MP picture in JPG100 format and have a more expensive class 6 SD card (which you can be sure IS a class 6) you are able to write the 1.9MB image in about 1/3rd a second. If you are using a cheap class 6 (that is actually a class 2) you can only write the image in about 1 second. This may be fine for still photography or portraits, but if you are shooting in burst mode, this can cause some problems.
Fortunatly, most SLR's (all that I know of) have a built in memory buffer that will hold the image until it can be written.... this greatly incrases your burst photography ablity. However, that buffer is limited, and if it can't write fast enough to the card, it will fill up, and the shutter of your camera will be disabled until the buffer has written the data to the card.
Bottom line here... and all technical googlebits and digibytes jargon asside... a cheap SD runs the risk of severly slowing down the burst capture of your camera... An expensive SD card may get you 5 frames per second, and a cheap one may only get you 2.
The second draw back, and this one is more hit or miss that the first, is the quality of the microchip and its ability to store data. Cheaper cards use cheaper chips, and while there are no moving parts to wear out in an SD card, the "disk" surface itself can wear out after repeated use and no longer be able to read or write. This limitation isn't as predominant has it was 10 years ago, even the cheapest cards are realitivly stable... but if you want to reduce the odds of losing data, a cheap card is a poor choice.
To summarize.... You certainly can use a cheap SD card, cheap SD cards will have no difference in image quality over a more expensive one, but you are going to be limited in your ability to do burst photography especially if you are shooting RAW images. This may or may not be a concern to you. And with a cheap SD card, you also run a slightly higher risk of the card itself failing.
Most any card with a name brand on it, Kingston, Kodak, SanDisk, Panasonic, PNY, HP... all of which are reputable cards and will do what they say they do.