I work with HP-UX exclusively for my $employer. I have a custom Perl installation, and commonly specify PREFIX=/foo/bar on the Makefile.PL invocation.

~, IIRC, is a shell meta character, and does not get expanded in the middle of a line. Use /home/foo instead of ~foo when calling the Makefile.PL file.