Move merge requests that are "ready to merge" or checks failed to the "Returned to you" list
<!--IssueSummary start-->
<details>
<summary>
Everyone can contribute. [Help move this issue forward](https://handbook.gitlab.com/handbook/marketing/developer-relations/contributor-success/community-contributors-workflows/#contributor-links) while earning points, leveling up and collecting rewards.
</summary>
- [Close this issue](https://contributors.gitlab.com/manage-issue?action=close&projectId=278964&issueIid=524217)
</details>
<!--IssueSummary end-->
## Proposal
When a merge request is `ready to merge`, it should be brought to the assignee's attention that they need to take action on the merge request.
During implementing #518710 with https://gitlab.com/gitlab-org/gitlab/-/merge_requests/183524, it was discussed that it was not possible to do this at the moment https://gitlab.com/gitlab-org/gitlab/-/merge_requests/183524#note_2382823589 and any client side processing could display inaccurate information especially in the case of many merge requests which would require pagination.
### Other scenarios
- When checks fail or pipelines fail https://gitlab.com/gitlab-org/gitlab/-/issues/542823#note_2556078708, this should return to the an active list so that the author can take action
issue