How to DROP multiple tables from databases?
Since you only have to do it once, forget the fancy batch job and just get on with each task.  Assuming you know the table names, you just do this sort of thing.

For each table with foreign keys, drop the foreign key constraint on that field.  Then depending on your requirement, you can add records to the table that should have the data and add a new foreign key, or, simply delete those records.  Then you can drop the table.

Much of this work can be done with SSMS so you might not have to write that many queries.