I think you're misunderstanding the point of the proposition a little bit. It's not just about recovering direct damages to neighbors (e.g. noise). It's about using incentives to crowdsource enforcement that the city doesn't have the resources to do.
You can be guaranteed that that there will be lawyers taking up cases (possibly on contingency) for the most frivolous of claims and offering to settle for a few grand (much less than it would cost to defend the case).
Though I don't live in SF and likely never will, so I guess if SF wants to get even crazier than it already is, it can. I have no power to vote in city level stuff in SF.
There is a famous story of the old west. Unfortunately, I can't remember names at the moment to even google it, but supposedly some saddles were stolen and someone was hired to get them back. He ran around shooting people on the brand of saddles that had been stolen. More saddles were returned to the seller than had been stolen. Even people who had actually purchased one no longer wanted to be seen sitting on one.
So I realize the law does not technically make it illegal to have your aunt visit. But if the effect is that you might get sued, the de facto outcome might be that you stop letting relatives come visit if you live in SF because the risk involved in doing something completely legal is nonetheless too high.