Thank you so much for that, exactly what I was looking for. Big bear does not have a good ROI for this, as far as I can tell, for the reason you mention. But the place is booming, town renovations, new restaurants, influx of corporate capital (for better or worse).
You would probably have to be in the top percentile to cashflow well with a 20% down deal, and really work for it, make it stand out, etc. I know one neighbor of my friends cabin that makes about 1k/month positive cashflow, but he keeps the rate lower and rents to anyone. its a typical 3 bed 2 bath roughly 1500 sq ft unit in a good neighborhood, walking distance to town or slopes (also where mine will be). But he never uses that one. It is not a stand-out cabin per se, but his strategy as mentioned is low rate/rent to anyone, and is established. I think he is around 180-250/night.
My unit is almost 2k sq feet, 4 bedroom, with a great back yard/deck that has a ton of trees, and hardly any view of neighbors (rare for the area). When you are on the rear deck in the spa, you feel like the forest is yours (which is why we went for this place). I hope to average 350-400/night (factoring peak pricing), but not rent it all the time. Some vacation rental company's analysys says I can get 425/night average with some minor tweaks, which I take with a grain of salt. If I could cover at least half or 3/4 of my nut and still use it fairly often, I would be happy. There are far fewer 4 beds vs 3 beds, and my un-tested strategy is to get that extra bedroom to help rent to double-families who can split the bill.
In Big Bear, as probably with any other mountain town, the nice stuff in good locations sell instantly. The rest sits and chases prices down. Our unit needs a lot of cosmetic work, deferred maintenance and updates. But the bones and location are great.
If you are investing across the US, my un-experienced feeling is that there are better places to get a higher ROI than Big Bear. But its awesome for those of us that live near the ocean in So Cal, and can zip up to the cabin/snow/cool summer air in 2 hours.