It's very country dependent. In NL, NZ, and UK (as of several years ago when I last did that) for example, no ID checks are required. In AU they are.
When I traveled to Europe recently and bought a French tourist sim, the carrier warned me multiple times that I need to provide my identity to continue using it beyond 30 days.
In UAE it's about as strict as in Russia.