This post does not answer your question but maybe will make you manage your expectations differently in the future.

When it comes to work, no company has your best interests in minds unless they align with theirs.

Never believe promises of future improvement. Whether that is a promotion, relocation you want or don't want and they don't want or want you to, change to a more interesting position, anything.

If you believe the "maybe one day", they'll milk you as long as they can until you decide they're not doing anything about it. It's not profitable.

It's not profitable to keep employees happy. It's easier to keep them for as long as they can as cheap as they can and replace them when needed. The time it takes a manager to allocate you to another project or location is better spent recruiting 3 new people for said location.

You should not be loyal to any company. It's a transaction. They pay you for your time. Don't give them time they are not paying for. Don't be loyal. If a company wants to fire you, they won't hesitate. Be friend with coworkers if you want, person to person. Not to the company.

HR is there to protect the company, not you.

Exceptions are rare. And probably all of said exceptions are in small companies, and with someone above you who cares about you and has some decision power. But it's rare.

Just keep in mind: no matter how good a company is, when they want to fire you, they won't hesitate. Even if you just lost your marriage, house, and a relative perished the day before. That's not their problem.

So, when things are always behind schedule and asking overtime is the norm: "Your lack of planning does not constitute an emergency on my part". You pay with your time.

I'm sorry for the grim point of view.