We have raised our kids with no family around because both my parents and my husband's parents are dead. So we don't know any difference and we've always had great friends and a "support network" to help us with childcare. When my older two were super young, DH was on the road for 2 years so I hired a live in au pair which was a great option.
Anyway - I do know that for many people, when they start having children, they suddenly have that "pull" to be back near family and often move back closer to home. So it's definitely doable but you won't know how you feel until the kids are here