On my Mac Pro 8 core with 16GB RAM it makes a whopping difference in responsiveness. I hardly ever get beachballs since 64bit.
I didn't realize my 2008 MP at work wasn't booting in 64-bit by default. Just changed the boot preference to do this by default now. Can't wait to see if it makes a difference (I've got 16 GB's RAM in there, too).