Create multiple queries from a single query

Not to my knowledge. Power Query cannot create queries, rename them, delete them, or even identify them. THat is all "above" the layer of the M language. If all of those tables are the same format, you can use the Combine feature to bring them all in at once. But if they are not, and need to be brought in as separate queries with their own formatting, you will have to do as you explained. and then apply the relevant transformation steps if necessary.

I do not think it is supported, but you could conceivably do this with C scripts in Tabular Editor if you could get T/E to know the names of the tables, but I'm not sure how you could successfully pass that info to T/E, so I'm still thinking no.