Charge transfer excitations from particle-particle random phase approximation-Opportunities and challenges arising from two-electron deficient systems.