My go to disk space inspector has always been the free Grand Perspective, such a useful and clever way to show disk usage graphically.

You’ll be able to quickly see what folders are taking up space and more so easily see what folders and files in those folders are taking up the most space.

http://grandperspectiv.sourceforge.net/

+1 for Grand Perspective, already helped me lots of times

This is the sort of app I hope we won't lose as part of the transition to Apple Silicon.