any other women that thought about being the provider?

me n my BF are currently talking about having kid(s) and knowing how family centred he is and seeing how great he is with his nieces/nephews little cousins etc i can't help but wonder if he might be better suited to being the one at home while i work. it was little more than a passing thought but can't help but wonder if anyone else has this arrangement n could offer thoughts/experiences?