Since the user's home directory is ftp://mywebsite.com/upload/users/ they'll automatically be directed there when they log in.

Just use the root of your site and it will work.

Ran a quick test on my FTP server and it worked fine with a limited account.