Sir, Greetings.
I'm using below card that came along D5. This is the G series and fastest XQD. The M series has max write speed of 150 MB/s. In B&H the cost of G and M series is nearly the same therefore buying G is better for write speed, which is more important when shooting.
Sony 128GB XQD G Series Memory Card
- 128GB Storage Capacity
- Max. Read Speed: 440 MB/s
- Max. Write Speed: 400 MB/s
I have also been shooting from two years with slower card that came with my D4.
Sony 32GB M Series XQD Memory Card
In practice even while shooting fast sports like football with D4 and M series card, I never ran out of buffer even once.
Unfortunately I haven't shot at all with D5 and D500 even after getting it from one month. I am sure it will be much, much faster then the D4 combination, however that won't be any advantage to my photography. I have seen on net, both D5 and D500 with XQD G series card shooting non stop and will only stop when the shutter busts.
As for video and even shooting in 4k, (actually UHD) you don't need a fast bust write card like XQD which has variable speed and max out 400 MB/s in case of G series, but a constant write speed which is noted in SD card like Class 10 or U3.
Which means Class 10 will never write slower than 10 MB/s and U3 means, will never write slower than 30 MB/s. For video constant speed is useful.
Also to add to this confusion SD cards have a new version from UHS-I to UHS-II which has faster read/write speed and ideal for 4k video. UHS-I cards support up to 104 MB/s, and UHS-II cards support up to 312 MB/s.
However, UHS-II are very expensive. I feel if you want to shoot 4k occasionally, SD card UHS-I rated U3 (3 is written inside U) should suffice. Of, course any XQD card will also work for video.
I hope you are aware shooting in 4k video with D500 will gave x2 crop and with D5 x 1.5. HD video uses full sensor.
Henry