Title should have mentioned that this is mostly about selenium. Different types of automation have different ROI profiles. Also, maybe some companies have a UI defect cost high enough to warrant the use of Selenium tests. All of this is so context dependent.
Some of that context: Vendor of software for debugging in production says automated testing doesn’t work.