Probably just another thing EA didn't think through. You'd think family members and close friends could feel right at home when visiting you, and vice-versa, but nope. If you want to be able to do what you want at your friends and family's houses, you need to get the reward trait "always welcome". Which is something at least... Not sure if it works with households that you aren't currently playing though, like if you get that trait for grandma and then switch households and your sims won't get offended anymore when she cooks at their house. Never tried it myself.