personally I don't find this particularly unappealing and have often referred to myself as some sort of plumber. plumbing is all about connecting standardized interfaces (threads) and then some improvisation. in IT the amount of improvisation is higher due to less standardized interfaces and interfaces are more complex. but the analogy works and I enjoy thinking about how to make interfaces exchange information efficiently.

If you choose that direction, yes. But you can also choose integrator -> CPO.