Add a `:type` to all specs

What does this MR do?

This automatically adds a :type metadata to all specs. See https://github.com/palkan/test-prof/blob/master/guides/tag_prof.md#pro-tip-more-types.

Why was this MR needed?

This is useful to see what kind of specs are the worst, or if we want to run only a certain kind of specs per job etc.

Does this MR meet the acceptance criteria?

• Review
  • Has been reviewed by Backend
• Conform by the merge request performance guides
• Conform by the style guides
• Squashed related commits together

What are the relevant issue numbers?

Related to #37787.