Ability to create collection of all folders that contain a specific file type

The way to do it is via a script column which indicates if a folder has the type of file you're interested in, and then filter on that column.

There's a script already written here where you'd just need to edit the wildcard at the top:

Instructions on how to use the script are in this earlier post in the same thread (which has a slightly different script for finding something else):