I'm happy to say this nice story is more the norm than the exception. There are many long-time sponsor families in the area. We take 4 plebes every year, and have done so since 1996 - we are now enjoying watching those early crops head for command of their destroyers, or receive promotions in the management ranks of civilian corporations, or expand their families and come into full bloom wherever their journey has taken them. Sometimes it's just plain karma and chemistry, and plebes/mids and sponsor families click for a lifelong friendship. Sometimes those officially assigned drift off, but others get "adopted" in. There are many styles of sponsoring - and many mids don't find the program of interest at all - but for those who do, it can be mutually rewarding. Our approach is not mom-and-dad parenting; they have you for that. We provide mentoring similar to what we received as junior officers from senior officers, and on many occasions, tough love, by asking questions rather than telling them what they should do. Add in home-cooked meals, plenty of ice cream, dogs to play with, sofas to snooze on and quiet rooms for homework, and it makes a nice escape from Bancroft Hall. As can be predicted, we see the plebes a lot more than the upper class, who are out on weekends doing what young people should be doing, but who still roll in with a laundry bag on Sunday afternoons and looking for leftovers.
What is fun for us is the number of siblings we have sponsored - we have had 4 sisters from the same family, twin sisters, and assorted other combinations, and we have requested the younger sister in '18 of one who just graduated last Friday. It has brought new friends and "sponsor in-laws" into our lives from all over the country. We see our alumni sponsor family at weddings, reunions and all over the country when we travel.
There is usually a "Sponsor Social" the Sunday afternoon before PPW, when the sponsors come into Alumni Hall for a meet-and-greet with their assigned plebes.
Down the road, if you hear from your plebe that it just didn't work out with their assigned sponsor, they can always request reassignment, or drift along with roommates and friends, and they often are adopted. They will figure it out. For '14, we had 4 original assigned mids, plus 2 friends who just fit right in.
Feel free to PM me about sponsor program questions, and I'll answer based on our experience.