Your comment is right above someone saying RJ-45 may be the worst connector! That’s just the internet I guess.

I think both opinions are right. If you’re a professional working in the field, RJ-45/8P8C is awesome because you can do large runs of cable and crimp on connectors after which is a lifesaver. The longevity of the connector is less important than ease of installation/replacement. I’ve done a little work with marine ethernet and CAN which uses M8/M12 circular connectors and those are pretty painful in contrast.

For consumers, it’s exactly the opposite. They’re unlikely to have the tools to crimp connectors. Most cables off Amazon come with lots of plastic that makes the cables rigid so it’s a pain to route and use in a home.