I think you're all getting a bit carried away with the groupset as opposed to the whole package itself.
Sora is surprisingly good quality now days, its not the thumb shifters it used to be of old. Borrowing technology from 105 from the past trickled down itself. I mean as entry level basic bike which is what he's after claris is almost certainly more than acceptable!
The Giant Defy and Specialized Allez offer a good all round package. He's not getting them at RRP, so stop taking the RRP into account and pointing out btwins or merlins bikes. They are good value for money for what they are I agree, but build/construction are leaving a lot left to be desired I have found. Money has to be saved somewhere, and in terms of warranty and/or customer after service, its none-existent. Money has to be saved somewhere.
Remember he is planning to use it lightly and in good weather, he's not into sportives or anything yet, and not cycling back and forward to work. Almost any entry level bike would do this job realistically.
I think if you wanted road bike and not adventure/gravel grinder, then the Defy range (rather than the Revolt) is a very credible choice. Giant still have control in house of most of their production processes. Where-as specialized out-source a fair bit, but that doesn't make them worse per se, their contracts are worth a lot of money and they have great control over what is made for them, so it's essentially a very similar outcome.
Having bigged up the Defy, I think in terms of looks the new Allez is pretty good looking
As i said, you'd do worse to have either, but you're right, head to a bike shop, ride a few bikes, talk to the salesman, let them do what they do and form some of your own personal opinions. At the end of the day, you're spending the money, you're riding the bike, and you need to please you, not the internet