The UNIX-HATERS Handbook¹ may be a good place to start for a historical perspective, as are the hundreds of comments that land when it has come here²³. A bunch of the comments in the HN postings are from the authors of the essays in the book too.
¹ https://en.m.wikipedia.org/wiki/The_UNIX-HATERS_Handbook