Time is an air bubble trapped under a screen protector. It's annoying, and you can push it around to try to keep it out of the way, but you can never really fix it.
There's just too many inherently contradictory requirements for us to end up with a "good" system, and we just need to settle for good enough.

My dream is that we stop changing things. Whatever we have in time zone database today is what we stick with going forwards. No more dst shifts, no more tweaks to the zones, no more weird offsets and shifts, because we don't get to stop dealing with the old layout when we change, we just add a new one that we think is better.

For the most part, dealing with this stuff is a solved, shitty problem. It's when we change the rules that problems come up. Worse when we change them retroactively. (Territory disputes between nations have been resolved with the conclusion that land was actually in a different time zone in the past because it was actually in another country. Not a problem usually, unless there's a major stock exchange in an island that was transferred between nations and retroactively changing what time it was affects what laws were valid at the time certain transactions took place.