I'm sure I've not checked out a band because of the name but for one I like I don't think it has decreased my enjoyment. Tropical Fuck Storm is hard to recommend to everyone though.
Not sure if I like Black Country, New Road’s music or not, but I sure hate their name. It could work as an album title, but it just doesn’t work for me as a band name.