The Problem With the 'Prayers of the People' in the Novus Ordo Mass

I'm sure there are at least 'guidelines' in the Missal or the GIRM, but how often are they followed? Not only do they tend to be freeform (so the Celebrant or 'reader' can insert their own favourite social justice theme), but especially at daily Mass, it's not unusual for the Celebrant to 'open up the floor', allowing attendees to offer their own intentions.

This sounds cute, but it can cause serious problems. I have a friend who used to be Catholic. Why is he no longer? Well, a number of years ago he was a devout lector and EMHC in his Novus Ordo Parish. He attended daily Mass as often as he could. On one occasion (his last as a Catholic) he was hearing Mass in a Church in Berkeley, CA. The Celebrant opened up the floor on the Prayers of the People. It was during the US action in Iraq and Afghanistan, and a female SJW prayed, not for peace, but that the American soldiers would be killed and the enemy victorious!

My friend just happened to have a brother on the front lines. Besides the normal dangers of an artilleryman in a war zone, his brother was also an EMHC, taking Holy Communion to men in the forward firebases who couldn't attend Mass. And a half witted SJW had just prayed that he would be killed!

My friend stood up, walked out of the Church and has never darkened the door of a Catholic Church since! In fact, he ended up leaving Christianity entirely, becoming a member of the pagan Mormon cult.