is there a way to create an AFP link to point to any user's home directory?
Well simplest way would be ~/Dropbox/shared/example.pdf (~ denotes user folder) but that will not probably work right from email.
You have to put it in Finder's 'Go to Folder...' dialog window which you can invoke with cmd+shift+G shortcut.