My new M1 MBP runs out of battery over a 3 day weekend of sleeping without charge ( the only way to make it sleep is to disconnect the charger, otherwise it refuses, probably due to the external screen connected).
i'll counter your anecdotal data point with mine, my m1 stayed alive in sleep for 3 weeks while i was on holiday and had hours of battery life left when i opened it up.