My son put it very well 3 years ago when I was debating what to get on the Model 3. He said "if you're going to buy a Tesla, for Xist's sake, that's what it's all about. Get all the automation it's capable of". If you can afford a full Tesla, and enjoy being part of something new, by all means get it. It's silly to spend the money on a half a Tesla. NOA has gotten so good I can't imagine driving on freeways without it. With FSD Beta, it's becoming a seamless continuum between freeways, unprotected highways, and streets.
Yeah, Level 5 is a Red Herring. It's never been done before. Personally, I don't care, sleeping at the wheel is not in my plans. It's good and getting greater with every update. And it's an amazing adventure. Like being there as the first aircraft or the printing press were developed. If you're strictly the utilitarian type, and all you want is to sleep while it drives, there are reasons why this is not for you.
But I think the naysayers largely fall into 2 classes. The theoreticians and ROI jockeys who don't have it, and so don't know what they're talking about, and the few who got it, but haven't put in the time/effort to get good at using it. You don't have to use all the automation all the time, but as it evolves and you get used to it, you will. If you don't get it, you'll get more P'd off every day, watching the gala train go by.
.