@escapedpolarbear I definitely understand what you're describing. The reason I asked about mods is that there's a very common reason why you'd get the "No interactions Available" text, and a couple of mods both make this more likely and easier to fix. Speficially, if the game leaves the house "open"—i.e. your sims have been greeted and invited inside—you wouldn't be able to "visit" again. That's why I asked if you could send your sims somewhere directly inside the house. But if your sims can't access the premises, then something different is happening.
If I were in your position, I'd try clicking on the icon for every house in town and make a list of those with no interactions available. Then I'd go to Edit Town and switch households, save as (with a different name so I didn't overwrite my original save), quit (without saving), delete the five cache files in my game folder, reload, and see if the sims I'm now using could visit any of the affected families. This would tell me whether the problem was my original family, a few of the townie households, or some potentially more serious game corruption.
If you can't visit the affected homes even after switching to a new household, then you can evict those households, save their houses to the bin, bulldoze the lots, replace the houses with the bin copies, and move the families back in, all in one Edit Town session. This should clear up the problem, unless you have more game corruption overall.
If the problem is your own sim family, the same process as above will work on them too, although again, they'll lose their promised wishes and opportunities. (They'll keep their jobs and relationships as long as you don't replace the sims themselves with a bin copy.)
Again, it's always best to experiment on a copy of your save so that you have the original to revert to if something goes wrong.