How to get statics on OS X finder folder visits?
You can create a Smart Folder (which continually updates with the results of a Spotlight search).

Open the target folder (e.g. Documents, your user home, Macintosh HD, etc) in a new folder.
Click on File > New Smart Folder
Click + to add additional criteria.
Set the criteria as Modified within the last 7 days.
Set the Kind to Folder.



You can save the Smart Folder in the Sidebar.

This won't give you a 'leader board' of Most Visited Folders, but it will give you some idea of what you've been doing recently.