Not sure if I locked myself out of anything regarding it, but I'm on around Day 120 and I only just now discovered how to access the Pool area at the Motel

.
I love sandbox games when they're done (imo) well. I like them for their interactivity, and for things like progression and unlocking new and repeatable scenes, new outifts, activities, etc. Things that make it feel like an adult
game rather than just a kinetic novel. But some of the common pitfalls with them involve balancing grind, and having unclear direction. Ideally, if a sandbox game is done really well, then there is no need for an external walkthrough. Everything that you need to unlock everything in the game can be found
within the game. Another potential problem (again, imo) can be when, like you said, certain hot scenes can get locked out or even missed entirely because you somehow advanced things too far too fast in some way.
This game isn't perfect, and is rough around the edges in places, but so far I think the good far outweighs the bad and I'm glad I gave it a try. Right now my experience with it is basically me progressing until I get stuck or lost, minimizing the game so that I can refer to your chart, and then going back in lol. Another downside to that is that the screenshots in the guide kind of "spoil" what the scene is going to look like. But I guess it is kind of necessary in order to confirm that it is indeed the right scene that you've unlocked.