As this issue is merged into Drupal 9.4, it fixes the adding the relationship into view automatically for all entities.
But the above patch is not adding filter user_name for node_revision, media_revision and block_content_revision table.
Eg,
$data['node_revision']['revision_uid']['help'] = $this->t('The user who created the revision.');
$data['node_revision']['revision_uid']['relationship']['label'] = $this->t('revision user');
$data['node_revision']['revision_uid']['filter']['id'] = 'user_name';
$data['node_revision']['table']['join']['node_field_data']['left_field'] = 'vid';
$data['node_revision']['table']['join']['node_field_data']['field'] = 'vid';
Similarly for media_revision and block_content_revision as well.
Before Drupal 9.4 if the content view is using the "Revision User" field was showing the username for the current revision now showing User ID instead of Username and it is breaking the display.
Drupal 9.3 - Revision User Field:
Drupal 9.4 - Revision User Field:
There are related issues with "Revision User" field to show the author name it was added into Drupal core 8.9 onwards and now it got removed again.
https://www.drupal.org/project/drupal/issues/2769289
https://www.drupal.org/project/drupal/issues/3113986