I can see a user's website under www.xyz.tld/users/testuser, but not under www.xyz.tld/~testuser.

Comment out the lines

AddModule mod_userdir

and

LoadModule mod_userdir

in your httpd.conf and restart your Apache.