SQL Server RDS Database Restore from S3 stuck in Restore Mode
It's not stuck, it's just still in restore mode because you used @with_norecovery = 1. You need to restore database with recovery to finish the process.