I have been using Oracle GoldenGate since 2011, right 2 years after Oracle acquired the company. It was an awesome project back then with version 10, but Oracle has continued adding tonnes of features to it ever since and this is just the best replication solution i have worked with.
I have done all kinds of replication using Oracle GoldenGate. Be it homogeneous, heterogeneous, unidirectional, bidirectional, on premise , on cloud (Oracle Public Cloud), integrating with JMS (Java Messaging System), we have done it all. We have loved the product so much that we have over years replaced all our existing replication infrastructure using Oracle GoldenGate.
I love that you can perform changes in almost zero downtime, replicate millions of data in sub seconds and their is large online documentations and forums to help you with troubleshooting any problems.
This doesn't requires a lot of expertise to begin with and overtime, you will love working on it.
Oracle GoldenGate now also comes with many GUI based tools like OGG Studio, OGG Director, OGG Monitor and OGG Veridata. These come with additional cost, but are great add-ons.
I am an Oracle GoldenGate fan, so it's hard to say what i dislike about it. But yes, i would have loved if it was easier to find syntax errors in your GoldenGate commands. Sometimes it just tells you ambiguous generic error messages for a syntax error. Although, with experience on working with OGG, you can easily overcome with this slight drawback.
We implemented Oracle GoldenGate on at least 400 database environments. We have a large infrastructure with tonnes of applications to assign installation and repair jobs to field technicians. In some of the applications, we can't afford latency or replication errors. GoldenGate has been a great tool.