Set spec type :rubocop for all Rubocop specs [RUN AS-IF-FOSS]

What does this MR do?

This includes some helpful Rubocop helpers for every Rubocop spec automatically and reduces the noise of adding type: :rubocop.

Supports !51005 (merged).

Does this MR meet the acceptance criteria?

Conformity

• [-] Changelog entry
• [-] Documentation (if required)
• Code review guidelines
• Merge request performance guidelines
• Style guides
• [-] Database guides
• [-] Separation of EE specific content