These data structures are good for main memory. I've implemented in-memory B-trees in C#, and they were 2x to 5x faster than .NET's built-in sorted maps. The built-in sorted maps also used 3x as much memory. Surprisingly, B-trees are better even for immutable collections, beating the built-in .NET immutable sorted map by 3x to 5x on updates. This is all with a straightforward implementation.
Red-black trees and AVL trees should not be used any more in my opinion. They are much slower and in my opinion B-trees are easier to understand and implement. It is still customary for data structure courses to teach red-black trees and AVL trees, but they should teach B-trees instead.
The linux scheduler uses red and black trees, there doesn't seem to be any performance problem there. I think that's a pretty ringing endorsement of the dsta structure no?
B-Trees are quite popular in-memory structures when focusing on performance. I expect the others could be adapted as well (and likely have been). A quick google turns up http://www.cs.cmu.edu/~chensm/papers/fpbtree.pdf
This reminded me of BetrFS presented at FAST 15. It looks like there's a more up to date presentation online[1] where the delete performance issues have been fixed.
This basic assumption mistake really changes a lot of the numbers in the article.