I mean... It's hard to really find solid numbers because Bethesda hasn't published them, but we know that Prey's opening week of sales was 60% less than Dishonored 2's was. All the estimates and discussion i can find on the Internet either concludes that the game lost money or, at best, broke about even.
It got great critical reviews. People who identify as "gamers" seemed to love it. But it gets compared to Bioshock a lot- Bioshock Infinite came out 4 years earlier and the market was saturated with similar games by the time Prey came out.
So I don't think it's unreasonable for management to want to move in a different direction. That direction ended up being a terrible one with Redfall, but i can't automatically assume that the studio would have been any better off making another game like Prey.
You can find every example you could look for in history. Studios who changed direction successfully, like Insomniac going from FPS to 3D platformer. Gamefreak went from platformers like Pulseman to making JRPG's and ended up making the most successful media franchise in history, while all of their later attempts to do anything else have failed miserably.
And it's not as if it would have made sense to have Arkane make Weird West. You can't just slash a AAA studio down to an indie overnight.
What the fuck are "modding values"? Women with ridiculous anime proportions and almost non-existent armor? Adding Shrek and Thomas the Tank to Skyrim? Gatekeeping mods to a small community of individuals who play on PC and have the technical skills to do that? Slaving away while the rent and bills like up out of some sense of obligation to a community? Hoping people donate? Putting all the time and effort into creating something and taking on all of the risk? Being. Subject to the whims of Bethesda's management and hoping management doesn't change their tune to be more like Nintendo?
How can you calin that Bethesda doesn't give a shit about modders getting paid, when they pioneered the first real legitimate attempt at paying modders? That's some serious cognitive dissonance. And perhaps the most important piece of the equation is the financial security it provides. The Creation Club paying modders up-front greatly mitigates the business risks of investing that much time and effort. It is not the best fit for everyone, but that allows a lot of mods to be made that never would have been possible otherwise. And it doesn't remove any of the mods that already existed or prevent anyone from making free non-CC mods.
As for donations to modders- those companies like Patreon are taking their own cut as well. And that's a legal grey area because modders are profitting off of Bethesda's platform. Then you have the issue where Bethesda updates their game and provides an improvement for literally millions of people while a couple hundred PC players flame them on Twitter for breaking the mod they paid or donated for.
Personally, I've never donated or paid for any mods because I don't use them. I've messed around with mods and the vast, vast majority of them suck. They feel completely out of place and ruin the vibe of the game. It's not worth all of the hassle of installing a mod manager and working through all of the issues just to add memes to the game. The ones that add more quest lines are usually just way worse versions of the radiant quests that already exist. Maybe if I had a more powerful computer back in like 2012 or 2013 then graphics mods might have made sense, but with the updates in the Special and Anniversary editions there's not much point. If I wanted to go back to Fallout 3 then maybe there's an argument there, but I'm not really interested in going back there in general.
The "best" mods can be created In a variety of ways. I'd argue that the Hearthfire, Dawngard, and Dragonborn DLC's are better than any free mod I've ever seen. The vast, vast majority of free mods are shitposts or school projects that no one cares about.