Tesla agreed with me that the second pattern is not preferable because the car/ computer never sleeps for the old Model S and cause a drain of 3% or more what is unacceptable.If you meant 1 to 2 hours awake then it's almost exactly the same ratio of asleep/awake in the MCU2, and the 2nd pattern is preferable to allow the car to handle abrupt weathers/draining of the 12V battery.
My car tends to sleep for exactly 58 minutes before becoming awake for 14 minutes. It would be interesting to gather more information about the sleep pattern in MCU1 cars or Model 3/Y, since people have said that their cars could sleep for hours/days but neglected to mention the awake periods.
With this sleep pattern, it's supposed to last 100 days from 100% (in reality it should be more since I'd expect at lower state of charge the car would sleep for longer). Based on what you said about the car losing 1% a day with the MCU1, and the ratio of sleep/awake cycles that would seem quite normal.
The first pattern has a lost of 1% a day and is the preferable pattern. The car can then go into sleep. With a software-update Tesla has solved the issue and the car now go to sleep.
charging a 12V battery is not something you do every hour. twice a day is enough if the drain consumption is low enough.