When I ran in person, I ran from my house. I had a dedicate gaming/activity area that had a separate entrance and a solid door to the stairs going upstairs. So I could have a group over without disturbing the rest of the family (and vice versa). I had run a game from a players house one or twice, I don't like lugging all my gaming stuff around.
Now I run my games online. When I'm back in my hometown, I'm fortunate to have a great FLGS that has private rooms, but I don't like to run games for my main campaign there. We'll usually play board games instead or I'll run a one-shot.
If you don't have good gaming store options nearby, check out your local libraries. In my area most have good meeting rooms which are available for free for residents with a library card to reserve. These are often better than getting a table in the common area of a gaming store. However, many of them have limits on how long you can use the conference room, but it differs from library to library.
Community centers may be another option, but in my area they are too costly for regular games.
Before COVID, there were a lot of companies that provided co‑working spaces. If everyone in the group were willing to pitch in, subscribing to a co‑working space could be affordable. Getting private conference rooms appropriate for gaming might be an added cost, however. Also, many of them just have glass walls and I would like to have more privacy.
When I was in New York, a lot of the delis/mini-grocers would have multiple levels for seating. They would be very busy during the day, but in the evenings they would be pretty dead with people just stopping in on an errand or if they did eat in would just get a table on the main level. So we would play in the empty lower or upper level. As long as we were buying snacks and drinks there, the owners didn't mind.