At the office, I use a machine which is used by several people.
Is there any way to enable File Vault ONLY for MY user folder? (I.e., /Users/me)
FileVault 1 used to do just this but the current FileVault 2 is whole disk encryption. It is technically possible to use the Logical Volume Manager underpinning FV2 to accomplish this, but it's rather complicated and not supported by Apple or any GUI System Preferences.
You could consider using an encrypted disk image created with DiskUtility. This would give you an optionally mountable disk that is encrypted. It appears on the HDD as a large file (like most installer .dmg files) and mounts with a double-click and password. This is similar to what FV1 used to do with a user's home directory.
Filevault 2 is full hard drive encryption. It is not possible to set that to a folder or single user.
However you can reenable the legacy file vault. This does what you are asking for. This does require some tinkering on the command line and is not for the faint of heart.
You can find instructions on http://www.taborcg.com/2011/10/16/how-to-enable-legacy-filevault-on-mac-osx-10-7-lion/.