That's disappointing to hear most families treat the detail like hired help. My older boy (18 at the time) walked 25 yards down hill to talk with the bugler. One of those small proud moments.
My experience is 4 decades old so I've no idea how consistent it is today. Back then, every family that requested a funeral detail, got the whole show - Every. Single. One. Pallbearers, rifle squad, bugler, OIC presenting the flag with the shell casings inside to the family .
Of course this is when the Army was
Yuge compared to today - double the size it is now. And this is when there were quite a LOT of WW2 veterans hitting their golden years.
Funeral detail duty constantly rotated among the battalions on post. If your BN had the duty, two details were trained in case the primary caught a funeral and another came in around the same time. My company got the duty twice and did three funerals combined all for WW2 vets. Two were for NCOs and one for an officer. I was in the firing squad for two of them. We were always told not to approach the family or engage with them out of respect, as you would imagine. I don't think any one of us thought we were the hired help. Even as a bunch of teenager/early 20 somethings we were humbled to be able to honor these WW2 vets. The families were dealing with their grief and we never expected them to engage with us.
On one of the NCO funerals, which was quite far from post and required us to stay overnight in a hotel, when we concluded the service, one of the veteran's sisters made it a point to thank every soldier in the detail. As you may know the firing squad and bugler stand some distance away, and even in that hot summer sun, we watched her trudge out to us in her black dress and thank us for honoring her brother. Talking about it on the drive back, you could tell every guy appreciated the importance of our responsibility to do this for the families.
In the 90s after the big RIF, I heard how things changed with sometimes no one showing up or maybe just a couple of Legion guys. It's a shame as the full service is such a great thing for the families.