LA is a draw to some, not everybody. For me, I had the choice to live there or a town I really like a lot in the Midwest. It was an easy choice for this native Californian who's been all over the country and has spent more than my fair share of time west of Denver and in SoCal. There is a bubble thing that happens with all these "reporters" who are based out of LA and it assumes everybody wants to live there. Nope. Some of us enjoy visiting it okay, but you can't pay to live there.
There should be little doubt that many prospective coaches would see red flags in Goff now. Some might see him and the lack of picks it took to get him as a plus, but I doubt all or even most would. What you can count on, however, is that whoever takes the job will say Goff was one of the reasons they wanted it. The personnel overall is a mismatch of parts with too many busts thrown in. But top coaches have egos, as is somewhat necessary for what they do, and it shouldn't be an overall deterrent.
I think some people mistake the NFL for MLB. In the NFL Green Bay can be a dream job as much as NY or LA can be. Coaches aren't constrained by a difference in resources based on the market and they can win just as easily in little Green Bay as they can big LA. And, their star will be just as bright if they do. So, I don't really buy into the narrative that every coach wants NY or LA. Every head coaching job in the NFL is going to be highly coveted since there's only 32 of them and no one gives them a resource advantage over the other. Ultimately maybe the coach himself has the ability to earn more in LA than other places, but of course, he also has the burden of having about 55% of that siphoned off the top for the privilege of living there where that's going to be a good 10% or so lower in most other places. So, bottom line is, I don't buy into the assumption. I think coaches with actual options first and foremost want to go where they can win, secondarily where they want to live and/or raise a family and probably down the list where they can squeeze out an extra few pennies from ancillary income channels.