Pros
Salesforce will train you to become an expert in its product suite, and also get certifications.
Cons
The role of the Success Architect, previously known as Program Architect, is very challenging. Clients typically sign a one year contract with salesforce for your services - so you are dedicated to one customer at a time, for one year at a time. The role is challenging since you get questions from everybody at the client ecosystem, from junior developers to CIO and BA's to Business leaders. You constantly move from technically complex issues to IT Strategy, adoption, and other matters. Pretty demanding. If you get an out of town customer, then you will be traveling as well (generally at least 50% - can be more). Evenings can be quite lonely since you are the only person from Salesforce services at this customer site.