Is SAP CPI a good career option?

Yes. SAP CPI integration consultants are in high demand due to increasing SAP S/4HANA and cloud implementations.