Battery/Alternator weird issues?

[Chucklez]

Hey guys me again! I swear every other month I got a weird issue with this car or something going bad on it...

Anyway so recently (past month or so) I was having massive battery drain issues from a faulty upper trunk hatch latch. Since then I have fixed it by just straight up unplugging it since at the moment I couldn't swing the $300+ dollars for the repair and it's not totally essential the car drives with with no trunk access.

Oddly enough once that got fixed I still was having weird battery issues. Car showing low battery or completely not starting at times, once I even had the car just completely die on me while driving. So I assumed it was the alternator right? Well I turn the car on and test that with a voltage meter and it's showing 14v output. So then I was like alright maybe it's the battery doing weird things, test the battery it shows 12v with the car off and took it to get tested and it showed it as all good.

So now I'm stumped and it's getting weirder and weirder. I haven't had my car die on me completely or anything but if it sits for over a die without starting the car battery is completely drained or dead won't start. Even if I do drive it every day, I ALWAYS get the red battery light on the dash which sometimes eventually goes away and other times my car completely goes into limp mode, 4x4 warning flashes on and off and on and off break warning on and off until it weirdly stabilizes and I get wherever I need in transmission failsafe mode.

Sooo yeah I have no idea what to do besides just buy a new alternator and test it? Any other ideas guys? Also per usual sorry for crap formatting if it is typing on my phone.