I'm trying to get all the AD users whose TS profilepath match a certain server but using the above command doesn't work, works fine for just profilepath or homedirectory but doesn't seem to work for either tsprofilepath or tshomedirectory, any ideas would be greatly appreciated

Get-QADUser has no TSPprofilePath parameter, try:

Get-QADUser -SizeLimit 0 | Where-Object {$_.TsProfilePath -like '*server*'}