As a Brit. smoker, it was only through Forums that I became aware of the culture of pipe collecting originating in US; we just smoked them!
Dunhills were always regarded as the first among equals in UK - Barlings, Comoys, Loewes etc, were just as good and, in particular, Charatans were thought of as excellent pipes (the straight grain on a "dead root" Dunhill would make a Charatan owner chuckle). Many blue collar Brits managed to acquire a Dunhill as a one-off present for a special birthday or retirement but they were not thought of as giving "bragging rights".
For collectors, I'm sure it's the ability to date them accurately that encouraged their popularity above some other old Brit. brands.
Of course they are good pipes, but as for a "life changing experience" I don't believe any brand of pipe can guarantee that; it's more the individual pipe than the name of the maker. I have Dunhills from 1944 through to 1982 and some are excellent (a '44, a '54 and a '81), others are very good, a couple are just "OK" and there is one "magic pipe" (a '62).
I'm not able to comment much on the difference between these good "factory pipes" and artisan pipes as there is little culture of individual carvers in UK [OK, Ashton (ex Dunhill), Upshall (ex Charatan), Ferndown (ex Dunhill) and now Northern Briars and Askwith pipes (which are excellent BTW)].
So, yes, they are as good as they look - but there are others and none are guaranteed to be magical (although they may shorten the odds).