Here's my experience, both as a child and now as the spouse...
My dad traveled Monday-Friday about 9 months out of the year when I was growing up; most of it was in state travel for the utility company, but he always made sure he was home for the "big" events- school, sports, etc. He and my mom had their routine and honestly, I remember my mom getting antsy when it was close to spring and waiting for the travel to begin again- she was ready for him to be out of the house for a few days
I don't feel like he missed much during the week, and I don't feel slighted that he traveled since he was there for the important things.
DH and I are currently living apart. He is 12 hours away at a school for his new federal job and has been there since October. DS and I have seen him 5 times since he's been gone, mostly 2-3 days at a time. He's there until May and then he moves to TX while we finish out the school year here and sell the house; DS and I aren't planning to move to TX until late July. Yes, it sucks, but we have our routine and honestly, when DH has been home, it takes some adjustment to that extra person in the routine. I'll be honest, it's been extremely hard on me, but most of that is the fact that we are moving at the end of all of this. DH was a police officer before this and worked from mid-afternoon to midnight, so many nights it was DS and I anyway. Plus, he's in the Army Reserves so we had some experience with 2-3 weeks apart; his one deployment was when DS was 2, so it was pretty easy overall.
It is nice to have that help with school, sick kid, etc, but this has proven to me that I'm strong enough to handle anything life can throw at me.
Best of luck with your decision, I know how much thought goes into it!
My dad traveled Monday-Friday about 9 months out of the year when I was growing up; most of it was in state travel for the utility company, but he always made sure he was home for the "big" events- school, sports, etc. He and my mom had their routine and honestly, I remember my mom getting antsy when it was close to spring and waiting for the travel to begin again- she was ready for him to be out of the house for a few days

DH and I are currently living apart. He is 12 hours away at a school for his new federal job and has been there since October. DS and I have seen him 5 times since he's been gone, mostly 2-3 days at a time. He's there until May and then he moves to TX while we finish out the school year here and sell the house; DS and I aren't planning to move to TX until late July. Yes, it sucks, but we have our routine and honestly, when DH has been home, it takes some adjustment to that extra person in the routine. I'll be honest, it's been extremely hard on me, but most of that is the fact that we are moving at the end of all of this. DH was a police officer before this and worked from mid-afternoon to midnight, so many nights it was DS and I anyway. Plus, he's in the Army Reserves so we had some experience with 2-3 weeks apart; his one deployment was when DS was 2, so it was pretty easy overall.
It is nice to have that help with school, sick kid, etc, but this has proven to me that I'm strong enough to handle anything life can throw at me.
Best of luck with your decision, I know how much thought goes into it!