Automate DBs restore through TSQL by given folders
I would suggest to use Restore Gene written by Paul Brewer.

There is a T-SQL [sp_RestoreGene] and PowerShell version [ps_RestoreGene] of it and you can use it / customize it as per your needs.

SQLServerCentral.com has an excellent article by the author on how to configure and describes the working of it as well - Restore Gene : Automating SQL Server Database Restores.