Added SSD to mid 2011 27" iMac. How do I keep user accounts on HDD and only use SSD for OS and Apps
Turns out it was just a permissions problem. Since macOS Sierra doesn't give you the ability to fix permissions, I'll just post this here in case anyone else needs it:

To reset permissions from the terminal:

diskutil resetUserPermissions / $(id -u)