Does homebrew usually put lots of files in the /usr/local folder itself?
Yes. That's how homebrew does.

You can usually trust 

brew doctor


to tell if things are correct - it is pretty good about flagging anything amiss in /usr/local. 

But to confirm your main question, the normal for homebrew it that it's noted for being "chatty" in that directory with many files and folders.