There are days and times that have a higher ratio of weaker (or inebriated) opponents, yes. This will mostly coincide with days/times where people who have jobs are not working, because generally, the more employed somebody is... the less study they have in the game, and the less seriously they take it.
There are also days that might be good to play, such as during big sporting events, certain holidays, etc.
But that being said, you also just need to practice basic table selection. For the most part the days of people just punting in hundreds of big blinds is over - even the weak recreational opponents often know they shouldn't be playing 70% of
hands and calling down with any pair to showdown. So you're mostly not going to be able to magically show up and have a whole poker room of tables where that's happening.
So this means picking the best out of your options. Imo play when is best for YOU, for your mental state and well-being. Then pick a good table when you do play, and just focus on playing well and enjoying it.
Live poker is largely a battle with yourself - just as much if not more so than a battle with your opponents. So maximizing your own performance imo is vastly more important than minimizing the skills of the opponents you sit with, but most people don't like working on that cause it's harder than just looking for a table where alcohol is flowing lol.