The ones used for 4K recordings are not slow 100+MBps, I won't say prone to failure as such, flash storage can only handle a finite number of writes but we can mitigate that by using wear leveling.
I wish SD Cards also had some specifications for random access speed.
I used to have a UHS-I SanDisk card which felt much faster than my current UHS-III Samsung card. It's really evident when searching through the storage, waiting for photo thumbnails to cache, etc..
I am not sure whether to go for a UHS-I SanDisk or UHS-III Samsung next. That SanDisk might not handle higher bitrate 4K.
The NVMe SSDs are very fasy - up to 4GB/s even for a not especially fast drive - because NVMe is an interface that connects to the PCI bus and depending on the PCI version and number of lanes in the NVMe interface (in that interface there are two variations for SSDs, so they can use 2 or 4 PCI lanes, with 4 lanes having twice the bandwidth that 2 lanes have).
The most recent version of NVMe SSDs which use PCIe version 4 can, when using 4 lanes, theoretically reach 8GB/s and there are already drives out there that get pretty close to it.
However some drives of a similar size and connector are not NVMe but actually SATA (same protocol as the older SSDs) and that stuff is limited to about 500MB/s same as the fastest SSDs from a few years ago.
I've recently got a mini PC and had to dive again into all this stuff (I've been doing the hardware update of my own desktop PCs for decades now and even building them from scratch but haven't had to look into it for several years) and the tech has really advanced since the earlier SSD days which were not that long ago.