I think the comments that I am about to make will inflame a lot of people, but from what I've seen it's the truth...So here goes.
I think that no matter what people will be unhappy with Fallout 4, modded or unmodded, DLC or no DLC.
Just like with the new Star Wars movie, just like with everything that's came out within the last 8 years or so. People over hype things, and then are angry when the final product does not meet their expectations.
It probably goes father back then 8 years, but it's just within the last 5 or so that it's really became noticeable to me. Fallout 4 is a fantastic game, no. It's a @#!$ing fantastic game. And yet people hate it. They don't like the story, it's too liner, the evil options are not evil enough. There is no resolution. The company has become too reliant on mods, no! Too reliant on DLC!
Now the saying that you cant please all the people all of the time is very true, but I think Bethesda is to be commended on Fallout 4. I've stated this before. The game is not perfect, it is not completely bug free. But have you seen most titles that come out now a days? Every major release I've seen from a company has been bug riddled upon release. You see this most often with MMO's but in standalone games as well.
The story is fine, it's just not the one you may want. I kinda hope Fallout 5 is a dark game where the protagonist unites many different groups of raiders into a super-powered force and takes over a area of the former US. Maybe that game will be dark enough for some people. But then again other people will hate it because it's too evil...