I really like Amazon's LPs, but I think they're often stretched to accommodate whatever opinion one has.
I've heard "I think this decision is not customer obsessed and we need to do better" in a lot of meetings. Make fun of the LPs all you want (I really get it), but they are definitely a net positive in the day-to-day.
However, I stand by my statement that they’re abused for propagating one’s own agenda.
Like you said there are adversarial LPs, and sometimes there is a clear winner but the opposing side can masquerade behind the opposing LP and make it seem like they’re in good faith.
They’re a net benefit for sure, but it really works best when you don’t have bad actors (I guess that’s probably true for all paradigms though).