1) “Are these mods available on console?”
2) “Why not?”
3) “If I keep asking, will that change?”

"No", "Because reasons", and "No".

Practical reasons

Discussed here.

Technical reasons

- PS4 doesn’t allow external assets like textures, meshes, voice files, scripts, etc.

- Xbox has a 2GB size limit for Fallout 4 mods, as of this writing. The combo of Project Valkyrie, Depravity, Outcasts & Remnants, and Fusion City Rising would exceed the limit.

- Fallout 4 isn’t available on Nintendo Switch at present, and even if it were, accessing mods (e.g. Skyrim mods) currently requires jail-breaking your game console.

- These quest mods use assets from other mods. Permission was granted to use those assets in a PC mod hosted on Nexus, but not on sites other than Nexus.

- The mods are designed for PC: they contain more NPC’s, larger interiors, and more intense battles than vanilla, things most PC’s can handle without any problem, but which could strain performance on a console.

- The mods potentially do not conform to Bethesda/Microsoft Terms of Service on account of child followers who can fight and take damage from enemy NPC’s.

- The Bethesda.net interface doesn’t allow for posting of mod documentation sufficient to support mods of this size and complexity. Even if there were documentation, you can’t use a console command to advance, skip, or cheat on a quest, or to customize something if you’re playing on console.

- The mods have not been tested on console, and no one has offered to buy consoles to allow mod author testing, or to thoroughly test the mods themselves.

- The combo of no testing, not being used to reading detailed mod page instructions, and no mod documentation to refer back to if a user gets stuck, could lead to frustration for certain console users, and we’d never hear the end of it.

Philosophical reasons

Nexus Mods is a community. Mod authors help one another and build upon each other's work. Nexus users also assist modders with quality feedback that lets mod authors hone their skills, and of course all of us as users benefit from the vast array of mods available on Nexus.

Bethesda.net, in its current state, doesn’t engender a similar symbiotic relationship. It’s more of a one way street - a content provider to consumer relationship, except the content providers don’t get paid. The amount of useful feedback available to mod authors on Bethesda.net can feel limited relative to the amount of trolling, theft, idiocy, etc., to the point where it is difficult for some mod authors to justify the time or effort required to host a mod there.

That’s not to say there aren’t great mods available on Bethesda.net. There are plenty, and future mods can also be designed for consoles, but for many mod authors, that would first require a compelling reason to do so.

In the meantime, I look at the Bethesda.net comments for excellent quest mods like “Tales from the Commonwealth” and “America Rising”, and my impression is….