This tool is available to all paid users in the Folders Tools sidebar.
The tool will count and list all* the folders in your Google Drive.
Results
Limitations
Free Gmail accounts with thousands of folders might give an error due to the timeout limit on running processes on these accounts. Paid Google Workspace accounts have higher limits.
Tested with a paid Google Workspace account with 5160 folders.