I honestly love the flavour perks that are in there. Sure, there are plently of them that are bad for your 'everyday build', meaning you use guns, a couple companions, and use armor/guns based on how far you've progressed and not really sought out specific/flavour ones.
The key, is that these perks can allow you to play the game an entirely different way if you want to. I recall players in FO3 who played as drug addicted scavengers, living in a crappy shack near the irradiated water, only crawling out of their dark spot to fill their craving for the next big high.
Other players have gone as all out cowboy characters, reproducing a style of gunslinging thats been uncommon for ages in 'Fallout time'.
It's cool for those reasons

But even cooler that you're not forced to take them if they dont suit your playstyle, allowing you to 'min/max' a character build if you want, or, to completely throw caution to the wind and build a helluva mess that can still beat the game

A lot of other games have tried VERY HARD to mimic this level of 'playstyle freedom', but very very few have done it so well