There should definitely be more page on the wiki on this. But on the Key:access page, it says under List of possible values for access=no: "No access for the general public. Consider using additional access (like foot=yes or bicycle=permissive, etc.) to indicate who can use the element."
And under Transport mode restrictions it gives the example of access=no + bus=yes, among others.
Also from the dedicated access=no page: "access=no, as any other access=* value may be overridden by more specific access tags. See access=* to see in detail how access restrictions are defined. E.g. a road tagged access=no and psv=yes generally withdraws any legal right of way but permits public service vehicles."
https://wiki.openstreetmap.org/wiki/Tag:access%3Dno
Probably don't have to revert the whole changeset, can just find the specific cases with overpass...I can do that if you want