Source: https://www.reddit.com/r/PowerShell/comments/fbcy5a/delete_users_in_cusersuserid_directory_and_remove/fj3nqvh?utm_source=share&utm_medium=web2x

Delete-Profile.ps1

Invoke-Command -ComputerName $WBComputers.Name -ScriptBlock {
  $GoneUsers = Get-WmiObject -Class win32_userprofile |
  Select-Object -Property *, @{
    NAME       = 'user'
    EXPRESSION = {
      ((New-Object -TypeName System.Security.Principal.SecurityIdentifier -ArgumentList ($_.SID)).Translate([System.Security.Principal.NTAccount])).Value
    }
  } |
  Where-Object -FilterScript {
    $_.User -eq $null
  }
  $GoneUsers | ForEach-Object -Process {
    if ($_.LocalPath) 
    { 
      $prof = Get-WmiObject -Class win32_userprofile -Filter "SID='$($_.SID)'"
      $prof.delete()

    }
  }
}