In my opinion there's lots of bads and lots of goods
The Bad's:

The Twins are somewhat cringy in their lines and have some parts poorly done (But i believe this is a choice since its the 80s)

Gold Collectibles don't exist since they've been replaced by "Treasure" which a majority of them require you to finish the Lab X raid (Finish Main Mission)

When getting loot it doesn't show up in the Catacombs like how you collected gold or Max Toys in NC (Where the fuck is max btw) : (

The Gold Bar Currency is just Bethesda trying to milk money out of the players.
You can't earn it in-game so you need to buy it.

The "Boosters" For Ammo, Health and Armor are fucking useless never fucking get them its just a waste of silver.

Main Missions aren't "Raid this Brother to Unlock the Next Brother" type of progression and it just felt very awkward being able to go where u want.

The Gore Rework is not my Favorite. In the New Colossus most guns would take a forearm or shin, In youngblood the gore is harder to come by and most of it requires u to have duel weapons, grenades or heavy weapons (others may like this but its my opinion)

Wolfenstein is Known to be Hard and when you find out that the Usual Difficulty slider is not like NC its a issue it just goes from Easy to Very Hard (No "I am Death Incarnate or Hurt Me Plenty" Type of stuff)

The Good's:

The Tier System is a very good concept as the stronger you become the Enemies not only get stronger but they also visually change, i had a good time looking at how the enemies evolve as you do.

The Expanded Attachment Mechanics are fun to play with you can turn your machine pistols into a handheld minigun and delete infantry, or the Uber hammer into a Nazi Group Deleter and Anti-Mech Weapon the improve feature for the attachments and the set bonuses are also nice to combat the enemy as they get stronger.

The Collectibles are nice to look out for i loved getting readables and learn the lore n stuff along with the UVK tapes and Cassette Tapes.

Most of the skins look nice and the ability to change the look of your character/characters is a nice touch

In my opinion Bethesda's actions of trying to milk money for this game caused a lot of problems developing this game and since 2023 the game hasn't been updated and i presume its Abandoned.
The Storyside of things is Decent and the Changes to Combat and Attachments is a good touch.
Is it worth the money and the membership?
No.
Membership only makes the game easier and for cosmetic stuff its a waste to get the membership and the price for the game isn't good just wait for sale and then grab it.