To start off this is a great no code product. If you ever heard of Zapier, Make, Pabbly Connect- this is the equivalent. From my initial skepticism of another no code software hitting the market, I was probably having the same thoughts you did. "Is this any different?", "Is it worth it?". But after using it for a few weeks now here are the pros:

1. Great UI (user interface)
2. You dont have to be a developer to understand how to use this. If this is your first time there is a little learning curve no matter what software you use and this is no different. 2-3 helpful videos or written tutorials from their community and you will be off and running
https://community.activepieces.com/c/tutorials/10
3. Price- currently I have Zapier ($20/m) and pay for the lowest tier which includes 750 zaps or tasks. That will get you a enough to do light automation but thats about it. After 4-5 months I was needing to upgrade. Good news with ActivePieces is they offer the starting tier at 10k ($89 LTD) and goes up from there.
4. Open Source- so since I am not a developer (and dont intend to be), I didnt really know what this meant at first. Basically this means that any developer that wants to work on developing more pieces or app connections for Active pieces can! This mean that Active Pieces is not limited to the bandwidth they have from their own team. Think of it like the equivalent of Wikipedia where you can help add useful content (except developers who help ActivePieces know what the heck they are doing haha).

Cons:
1. I wish I upgraded to tier 3 for more tasks available............. If ActivePieces team sees this, have mercy on me and consider upgrading me and I will happily pay!