Another value add archetype might be the "sounding board" partner. This is the person that listens to you vent, provides moral support, gives advice on non-prod

Another value add archetype might be the "sounding board" partner. This is the person that listens to you vent, provides moral support, gives advice on non-product related issues like personnel, politics, power plays, helps with strategy and negotiation, etc