As well as the warranty companies inspection, it may be advisable to get an independent inspection done on the car too. AA/RAC for example.
Yes, the VHC in main dealers is designed to 'upsell' work. Main dealers are there to make money after all and have monthly budget 'targets' and all that BS. Some do take the piss pushing techs to find work (mentioning no names) But in most cases VHC is a quick look around whilst doing the booked in job (service/mot) noting tyre depths and any obvious faults (clue is in the name 'visual health check') and takes about 0.3hrs (18mins)
By the look of the OPs report it's a write off!