Yes, that is now pretty much what I am doing. It's been like this:
The Door (sorry about 'Foor' in title) I keep locked because of intruders and paparazzi. If not, it's past annoying into upsetting since they shouldn't be there and don't want to leave. Either that or they just die somewhere in the house.
So I either have to invite the other Sim over and just unlock the door, click "No Trespassing", hope it's enough to keep intruders out, keep an eye on what's going on in the Sim house, let the Sim I want to to come in and then relock the door after they leave.
Either that, or if I want a Sim to visit another Sim, have them be invited in from the Sim inside of their house, and make sure they have Wellness 10 and let them teleport in.
A pain the rear. EA went too far with the need for door locking. But my Sims can visit. A difficulty, but they can visit