I have my first SP4 bought in 2017 and got the same battery drain issue even with proper shut down.
Nothing is helpful by updating firmware and drivers.
Then it got screen flicking problem, I send it back to Microsoft and they send me back a refurbished SP4. Since then there is no more battery drain issue when off.
Feels like there is hardware problem that MS don't want to admit, but if they think users already "consumed" certain part of the lifespan of the unit and should pay for that, at least they should offer special discount for renewing SP4s within a known range
of serial numbers.
My SP4 was replaced due to the flickering issue about 3 years ago and I noticed immediately that it suffered from a light battery drain (10 to 15% a day) but I was so happy to get a working tablet that I decided to keep it anyway also because the draining
was reduced to a 5-10% through disabling the "connected standby" feature; now in 48 hours or less without turning my sp4 on, the battery has no charge remaining (0%) and I noticed the issue has heavily started in August 2019. I use my sp4 only for web browsing,
checking email and similar things for 3-4 hours a week as it's not my main computer. My son bought a SP5 2,5 years ago that he's using maybe once a month or so and when it's turned on, its remaining charge is about 90%. It's clear that in some SP4 is definitely
a hardware issue with no doubt.
So I can second your "discount" request, even if it would be better for MS to admit the issue and find a satisfactory solution for everyone.