Just to update everyone on this and let you know what my experience has been so far.
I bought Sandisk Extreme 120MB/S UDMA 7 (whatever that means) card. I read the articles and links about them but my attention threshold for tedious technicalities relating to different speeds and standards is so low, I just went and bought that card and considered the matter forgotten. Until it arrived, and then I needed to try it all out, that is...
The tests that I conducted were very simple. The normal shooting mode (single shot - refocus - another shot and so on), worked very well on the normal setup (CF - main, SD - backup copy of everything). With this setup, when importing to the computer, all I needed to do was to stick my SD card into it and i liked that idea because it already has the SD slot, because I know people who bent the CF card slot pins in their Nikons by phaffing around with taking their CF card out and putting it back in again, and because I don't have and don't want to buy a CF adaptor (it's another thing and I lose things a lot).
The high speed burst, which is another shooting mode that I would be using, was a different matter. The above card setup worked OK at shooting (probably because there's buffer on camera where it goes first, I guess), but the writing (when the green "card in use" light stays on) took a good minute, I swear! This was the time I would be having an urge to take another photo burst, but I had to resort to tea making activities because the buffer was taken up and emptying very, v-e-r-y slowly. When I changed the card setup to overflow (CF - main, SD - overflow), this write process still took place, and the light stayed on, but it lasted about a second and a half.
So I went ahead and created myself my first two custom shooting modes

One - "Rabbit HQ Portrait" - has 14 but RAW image quality and the backup card setup, the other one - "Rabbit burst" - has 12 bit quality and the overflow card setup. (Nikon D300s cannot do high speed burst in 14 bit, but up until the point I acquired the camera, I used 12 but for many years and still I couldn't see a difference between the two colour settings... Maybe I need an IPS monitor for that, but that's a topic for another thread.) I use both modes regularly and so far everything suits me. Except that when I have to import my bursts I have to do this via a USB cable connection from camera to PC, but I do my bursts rarely and sparingly, so all suits me well so far.
I know I could upgrade the SD card, but on my quick and sparse reading about these various cards, I caught a glimpse somewhere of the assertion that they're still not as fast as CF's anyway and I saw some fast ones and they cost heaps of money and apparently they're not as good anyway... And even if they're pretty fast, I figure there's still going to be at least two-fold increase in the writing lag as I don't believe the buffer will write to both cards at once... or will it? I might try it out one day with someone else's fast SD, but for now, I have it kinda figured and it kinda works.