See this blog post for some data at the end:

https://www.sebastien-han.fr/blog/2014/10/10/ceph-how-to-tes...

The post is from 2014, but the performance data was updated for many years after that.

As you can see, there is not really 1 brand to single out.

That Micron P400e was a pain to swap out in production, and if you use consumer drives there is even worse out there.

Note: this post is on something very specific about Ceph, but the idea translates to any other workload that does syncs (including LVM cache scenarios).