Nope. To browse it from Finder a separate program is a must. I recommend PhoneDisk.
Did you even look at PhoneDisk? It integrates into Finder as well.
On Lion?
Yep, installed it off cydia, then the iPhone just appeared in finder, entered my username and password and done, simple.