Running 22H2 with latest updates.
I ran chkdsk /r c: and rebooted, and finished the repairs.
I didn't have to clear the temp or run the script, as the import wizard worked flawlessly. The last time I tested (when the original query was posted) I got the "Try again" option. Chkdsk may have fixed something I think. I use the same cable even now.
I used a very basic low-end Android phone.
I also ran chkdsk today on both the windows 10 and windows 11 hard drives which took 3 hours+ then rebooted ran into the same problems then I deleted the photos app using powershell and redownloaded it and then I deleted an app called sandboxie plus for windows 10 rebooted and tried again this time using only Photos app it detected 7599 items but it wouldn't show any pictures as it would stuck on that screen, than I ran the classic windows 10 import pictures and videos and it detected the pictures with the correct thumbnails but I dont know the number of picture that got detected as I was talking to someone on the phone. I will try once again and see how many pictures are being detected it should be around 7,000-8,000 items -- both videos and photos.
update: 7,000 items were found this time
update 2: using photos app only 5603 items are being detected since the past 10 minutes I don't know if it's stuck or not. A progress bar with which locations photos is working on would be very useful to see where it gets stuck