There have been quite a few workarounds posted in this thread that have worked for various people. So far the solutions seem to fall into 3 main classes:
1. Reset and restarts with changing cables and ports
2. Deleting iPod Photo Cache
3. Roll back to iTunes 12.7.3
Solution 2 worked for me although it still took 5 hours to sync 5000 photos on a USB 2 port. I have now implemented solution 3 and will report the time to sync.
Each of these solutions seem to work for someone, but not everyone. I'm sure there are lots of people happily synching photos under Windows 10, iTunes 12.7.4 and iOS 11.3.1.
I hope your trip to Brentcross Apple Store provides a usable solution for you. Hopefully it will work for everyone, but I will not hold my breath because Windows 10 exists in so many forms, on so many platforms, plus the different generations of iPad, and iPhone.
I believe this is why Apple is struggling to provide a solid solution to this issue. There are a huge number of combinations to consider - especially those combinations that don't have this issue. If the Apple developers cannot produce a well documented, reliably repeatable scenario, then resolution will be a nightmare. It could be that this issue exists for just a few dozen rare cases in the context of millions of users who do not have this issue.
If this issue was affecting 10% of Apple customers, I would expect a significant coverage in the technical press. But there's nothing I've heard of other than this thread. May be that's the real problem here - it's not a conspiracy to force unwanted solutions on unwilling customers, we're just a few dozen users who have fallen in the cracks between Microsoft and Apple.
Nonetheless, good luck with Brentcross Apple store - looking forward to the next episode.
Cheers
Ian