Memory card speed is confusing. There are different ways it is specified and advertised. The Read and Write speeds are different, NOT the same number.
There are three major types of memory cards used by cameras (each fits a different unique socket, NOT backwards compatible). Your camera has to be designed to accept them.
Class ratings (used by SD cards): Class 10 means 10 MB per second minimum, and it means the slowest of Read or Write will be at least the 10 megabytes per second. That will be Write speed, because Read is faster than Write. I don't know why Class 10 is still the highest number used, but it is a minimum. Many SD cards today have a UHS-1 interface, and are faster.
X ratings (used by Compact Flash cards): 400x means 400 times faster than the old first CD players which were 150 KB/second (which seems a pointless comparison today, but flash memory is older than digital cameras). But 400x means 400 x 150KB = 60 MB/second. This is Read speed, Write speed will be slower. Above 200x, the card will require a USB 3.0 port to ever see its full read speed.
Some of the faster cards have finally started just specifying the fastest speed as megabytes per second (MB/s). This will be maximum Read speed, Write will be slower (and your expected actual write speed will be difficult to determine when buying, and the speed in the camera is likely less than the speed in a computer).
There are now UHS-1 (Ultra High Speed) SD cards, and UDMA-7 Compact Flash cards, which are newer and faster, and are supported in newer cameras or card readers if so specified. These faster cards(of same type) are backwards compatible with older cameras, and vice versa. They will always work fine, they just run at the slowest speed supported. The card recommendations in your camera or card reader manuals will mention UHS-1 or UDMA-7 if supported.
SD cards have these size types (check the camera manual and card reader for types they support):
SD UHS U1 means Minimum write speed is 10 MB/second. UHS U3 (speed class 3) means Minimum write speed is 30 MB/second. The Nikon camera models (up through D750) support UHS-1. Write speed also depends on the device (or the specific camera model) doing the writing. For example, Sandisk advertises:
The XQD card is from Sony and Lexar so far, and are faster yet, like one variation is up to 400 MB/second writes. The new cameras are faster too, so these are finally able to handle writing long bursts of large raw files.
Point is, cameras have different processors and different card interfaces, and are also doing other work at the same time.
1000x is 150 MB/s, UDMA-7 maximum is 167 MB/s, and I see 125 MB/s read here (but same card setup on a USB 2.0 port starts with only Read 31 MB/s, Write 25 MB/s).
Copying a 3.6 GB file to 1000x card via same USB 3.0 setup, Windows 7 reports about 88 GB/s Write speed. Copying that file FROM the card to a system SSD drive reports about the same 125 GB/s. Galbraith tests Write speed of this 1000x card in a D800 to be 69 MB/s - and same card in a D700 was 42 MB/s (so, situations will vary the numbers).
So is the card faster than the camera can use? Not necessarily. Maybe cameras won't see the maximum speed, but the faster cards still go faster than the slower cards. And the card reader speed is important for large batches too.
Video use is slow and does not need much Write speed. The files might be large, but the camera has the full record time to write it. Nikon says use a Class 6 card or faster for HD video use. However, you certainly may want a card with much faster Read speed to download gigabytes of file to the computer.
Photographs: There is single shot mode, and continuous burst mode. There are large Raw files and smaller JPG files. All this affects the speed.
If you shoot JPG, a 24 megapixel image file is only about 12 MB. If you shoot one each second, that is only 12 MB per second needed for card speed. If you shoot continuous 5 frames per second, that is 60 MB/second. What is the point of a 95 MB/second card? You need a reason, but of course, downloading a few hundred files in the card reader is a good reason.
But if you shoot Raw, the files are much larger, maybe 22 MB, maybe 35 MB. Then 5 fps becomes 110 MB/second, or 175 MB/sec, and if you do more than a second or two burst of continuous large files (whatever the buffer can handle), you probably want all the card speed you can get (but SD and CF cards are not that fast).
But if you just take one picture at a time, card write speed is not much concern. Just watch the green LED on the rear of the camera (access light for the memory card), indicating when it is writing to the card. If that LED is only on for an instant, it is no concern. If it is on one full second after the shutter, is that actually important? Is it holding you back? The camera will still buffer additional shots. So within reason, Write speed is probably not much concern to most of us.
But note that when you Read hundreds of picture files into your computer, you will be thinking about a faster card and a USB 3.0 reader then.
In burst mode, the camera buffers up the several files, which are written as it can. You can evaluate the performance this way:
Example: A Raw file on a 36 megapixel D800 is around 40 MB. If you shoot a burst of five of them, that is 200 MB to be written (plug in your own numbers).
A Lexar 1000x Compact card writes for 3 more seconds after shutter stops (200 MB in 3 seconds is about 67 MB/second). Ron Galbraith says the D800 can write 69MB/sec to this 1000x card (200MB/69 is about 3 seconds).
An old Class 10 SD card writes for 19 seconds after shutter stops (200 MB in 19 seconds is about 10 MB/second). Which would not likely be acceptable in this mode.
Writing five smaller 12 MB JPG files is only 60 MB total, much less issue (even within 6 seconds on a Class 10 card). But burst mode is when you will want faster card Write speed.
However if just shooting one 12 MB JPG once every second, you only need 12 MB/second card write speed. And again, the camera will still buffer any second quick shot then.
Shooting video is not an issue - any Class 6 or 10 card. It has the full record run time to write it.
Write speed is not much issue for single photo shots. However, burst mode of large files is likely something different.
And did I mention that you always might want a faster card and USB 3.0 reader to download a few gigabytes to a computer? (which is not really about the camera.)