Can I make Calendar on OS X automatically show me more upcoming weeks when focusing on today?
I do not know about Automatic.

But if you just move (scroll) the today to the first line of the Month view, you will see the following 5 weeks.

Making it automatic is a problem, since the Month view is what it says. It has been set to show the month, while Today is a variable.