I think it depends on whether you want a career or just want money. I will take money. If at the end of my life, not a single thing I have coded has made a damn penny or been used by a single person, I am perfectly fine with that.
We are all mercenaries. If you buy into the mission statement, the management is actually good at selling their vision, you buy it because it resonates with you, you are the owner in some way or you are new to the game and are being used. Sadly, it is that simple.
I also disagree with the premise of "someone with 10-15 years experience who doesn't understand the big picture " example. Person in that example is an idiot. Doing something for over a decade and not knowing what they are doing after seeing different setups in different roles? I have yet to meet a person, who moved a lot, who does not have a well of experiences to draw from.
Learning how to say no is a very important skill. I think it's even better for compensation to find positions in which you are an inherently good fit to create value, and then negotiate to a level of compensation favorable enough that you don't need to think about it for a while.
As the Rolling Stone song goes, "You can't always get what you want; But if you try sometimes, well, you might find; You get what you need".
You could also use it as a stepping stone; be adaptable in the short term to build experience and salary, then you're in a stronger position further down the line when negotiating for the job you actually want.
Even if you just want money, the long term consequences are worth considering.