@SuperNTG Some community lots are rabbitholes, meaning sims walk in and disappear until they come out again. These include City Hall, the grocery store, the default restaurants, etc. For some of these, you can make your own replacements that sims will use for work; look up "Zerbu ultimate careers" if you're interested. The idea here is to create workspaces that sims use and that you can see rather than them disappearing from the map.
Community lots that are not rabbitholes—the library, the gym, clubs, etc.—can be viewed easily enough. Just zoom in on the lot and go down a couple of floors until you get the view you're looking for.
By default, all inactive sims' residences are "closed," meaning you can see the houses on the map but not what's inside. There is an NRaas mod called HomeOpener that makes all houses open by default, so they'd work like non-rabbithole community lots. However, using this mod in a medium or large world would be a significant drag on performance, so I'd only even suggest it if you were playing in a small world with a very limited number of households.
The alternative is to use NRaas MasterController to "open" whichever houses you want to view, then "close" them when you're done. The option is under the main NRaas MC menu when you click on the house itself or its map tag. I don't know how powerful your computer is, but I'd suggest not having more than about six households open at a time, and fewer if you notice performance issues. You could leave the same households open or rotate; it's up to you.
One note: if you do install HomeOpener and remove it later, you'll need to manually "close" each household.
Please also keep in mind that when sims are home, they're mostly not doing anything at all. The game will start to simulate them if you focus on them or "open" their house though. That's why having all houses open is such a drag: it takes more resources for the game engine to simulate every single resident at the same time. It might seem attractive, but you can't watch all of them at once, so there's no real benefit. StoryProgression will simulate their progression whether they're performing the actions on-screen or not.
Finally, a bit off-topic, I would suggest disabling memories, which is in the third or fourth Options page. Since you're not going to view them yourself, there's no point in having them, and they're a significant drag on performance and a major cause of save bloat, especially as time goes on. In case you'd rather have a few memories, there's a mod called "no (or fewer) automatic memories" by velocitygrass that works well, but like I said, you're not going to see the memories if you're not actively playing these sims.