Merrill - are you asking for people’s personal reactions or for something more general?
Brett is all around and in the past most wineries weren’t all that clean, so it was characteristic of many European wines from France, Spain, Italy, Greece, and so on. When people talk about “globalization”, one thing they’re talking about is clean winemaking because the bretty notes are gone from many wines these days.
The irony is that even in clean wineries, the wine making might help brett. It can grow very easily using the alcohol in the wine as a source of carbon, some amino acids in the wine for nitrogen, and even some of the sugars in barrel wood of the barrels, particularly the toasted ones. But it needs oxygen, so the trick is to deprive it of any oxygen. That’s the purpose of sulfur and therefore the trend to no sulfur is clearly beneficial to brett. As are higher sugar levels from riper grapes.
And then of course it multiplies much more rapidly at higher temps, so storage is an issue.
But not everything funky is brett. Sulfur that’s added to wine can form weird-smelling compounds all by itself. And we perceive things differently depending on their concentration. So the exact same molecule that may give a note of say, leather, may be really offensive if the concentration of it is doubled or tripled. And brett can manifest itself in many forms - I’m sure you’ve seen the brett aroma wheel.
As far as Pinot Noir and brett go, the brett from a ripe Sonoma PN may be entirely different from a PN from somewhere else in the world because the different components of the wine would be different. Some of the funk may just be from the reductive environment of the bottle and some from the grape. Tempranillo for example, has a distinctive funk to it. If a winery is super clean, the funk may not be apparent immediately, but last night I had one of those and it was 20 years old and now has that classic funky note and I’m sure it’s not brett - it’s just the signature of the grape, kind of mushroomy. PN has a distinctive note with age as well, but that’s always mixed with the grapey PN flavors that help to distinguish it in blind tastings. Brett adds another dimension.
Personally I tend not to like it in young, fruity wines, be it band aid, sweat, barnyard, or whatever. A hint of it in an older wine isn’t as offensive because it tends to mix with the other aromas and flavors of the mature wine, which aren’t so fruit-based.