### Description

Currently some code in RDS Operators use boto waiters and some uses a custom `_await_status`, the former is preferred over the later (waiters are vetted code provided by the boto sdk, they have features like exponential backoff, etc). See [this discussion thread](https://github.com/apache/airflow/pull/27076#discussion_r997325535) for more details/context.

### Use case/motivation

_No response_

### Related issues

_No response_

### Are you willing to submit a PR?

- [ ] Yes I am willing to submit a PR!

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)

_create_db_instance(self.hook)
        stop_db_instance = RdsStopDbOperator(
            task_id="test_stop_db_instance_create_snapshot",
            db_identifier=DB_INSTANCE_NAME,
            db_snapshot_identifier=DB_INSTANCE_SNAPSHOT,
        )
        _patch_hook_get_connection(stop_db_instance.hook)
        stop_db_instance.execute(None)
        describe_result = self.hook.conn.describe_db_instances(DBInstanceIdentifier=DB_INSTANCE_NAME)
        status = describe_result["DBInstances"][0]["DBInstanceStatus"]
        assert status == "stopped"
        snapshot_result = self.hook.conn.describe_db_snapshots(DBSnapshotIdentifier=DB_INSTANCE_SNAPSHOT)
        instance_snapshots = snapshot_result.get("DBSnapshots")
        assert instance_snapshots
        assert len(instance_snapshots) == 1
    @mock_rds
    @patch.object(RdsBaseOperator, "_await_status")
    def test_stop_db_cluster(self, mock_await_status):
        _create_db_cluster(self.hook)
        stop_db_cluster = RdsStopDbOperator(
            task_id="test_stop_db_cluster", db_identifier=DB_CLUSTER_NAME, db_type="cluster"
        )
        _patch_hook_get_connection(stop_db_cluster.hook)
        stop_db_cluster.execute(None)
        describe_result = self.hook.conn.describe_db_clusters(DBClusterIdentifier=DB_CLUSTER_NAME)
        status = describe_result["DBClusters"][0]["Status"]
        assert status == "stopped"
    @mock_rds
    def test_stop_db_cluster_create_snapshot_logs_warning_message(self, caplog):