think of them as commands that work on the data they are given. for example you can provide two data A and B and then call OP_EQUALVERIFY, this "command" checks if A and B are equal and if not it fails.
OP_RETURN is simplest of all, it doesn't need any data. whenever it is reached it immediately fails without any extra actions.
because of this, you can put literary anything after an OP_RETURN which is why it can be used to stored arbitrary data on the blockchain.
whenever you spend bitcoin, you are actually providing a script that any node can run (evaluate) and if didn't fail and returned true then the coins are considered spendable.
so when you have OP_RETURN and if you try spending it, the node fails immediately on that OP code and it makes these outputs unspendable.
what others in sidechains, altcoins (merged miners), pegged coins,... do with OP_RETURN has nothing to do with bitcoin. they can do whatever they want. any bitcoin sent to an OP_RETURN output is unspendable forever.
Yeah. Was thinking more about what Altcoins do with OP_RETURN than how it works on Bitcoin at the moment