Codepipline is a bit under-rated, because most people don't have the need for such a programmable CD tool. Every facet of the build pipeline can be configured, and cans end notifier events via AWS SQS. When you're already doing much through AWS, it can reduce hassle to maintain all of your ops code in one place.
I haven't seen other CD tools have this much programmability — and even where they may, I still hesitate at have too many things in too many disparate places. Also, CodePipeline as a full command-line interface.
There really is nothing user-friendly about it, when you compare it to tools like CodeShip or Ansible. CodePipeline is a 'programmers tool' — and so it lacks the 'ease' of interacting with it, which other tools have. Consider that every functionality of CodePipeline has a command-line equivalent.
When I've built things for smaller shops, it would be too much to hand-off to less-skilled engineers. This is also the case in medium-size companies, where there are enough smart people to do big things, but not enough of them to 'retune the engine regularly.' Even in a company with ~100 engineers, the ops group was small enough that CodePipeline was a bit much to setup and maintain with a complex build that involved a large tree of dependencies. In that particularly case, GoCD provided more up-front UI. It really comes down to what kind of people you have.
As with most AWS products, support is costly or hard to come by (unless you in a city that has an AWS Loft)
Look at the rest of my comments; decide whether your company size and team capabilities are right for codepipeline.
I've used, or attempted to use, CodePipeline in large and small companies. Large organizations with regulatory controls were where CodePipeline worked best for me, since every part of the system could be maintained in an orderly / regular manner. Also, consolidating billing with AWS simplified the POs and interaction with Finance. This ultimately lead to less time spent, organizationally, keeping proper financial controls and measure in place.