I've played Skyrim SE with the CC mods some more, so here are some updates:
Arcane Accessories: Turns out that the destruction spells added by this mod include some very powerful damage spells, including an expert level spell that costs less magicka than Incinerate, does more than double the damage, does both fire and shock damage, and also explodes in an AoE the same way Fireball does. This makes it the best destruction spell in the game, by far, for most situations. That's not to say I object to that, seeing how destruction really falls behind in damage compared to the weapon skills in late game, but it feels sleazy that they locked the official solution to that problem behind a paid mod.
Plague of the Dead: The "quest" included in this mod barely has substance, all it consists of is the player traveling to a specific area of the world, killing around 10 zombies there, and looting the spell tome to summon zombies off the corpses there. That's it. However, after you complete the quest, you may run into groups of zombies on the roads of Skyrim at night, which is a pretty rare but relatively fun occurrence. Zombies are melee fighters who do decent damage and have a lot of health, and they typically appear in groups of ~8, making them an interesting challenge. There's not a lot to this mod, but I like it regardless.
Ruin's Edge: The "quest" associated with this mod is also very simple. You go to a cave, kill a bandit leader who fights you with this bow, and you loot it off his body. It's otherwise just a regular artifact with a unique enchantment effect. I guess what I'm saying is only buy this if you're interested in the artifact, because the quest isn't worth it.
Stendarr's Hammer: Even flimsier excuse for a quest. Go to Markarth, enter Calcelmo's dwemer museum there, and steal the hammer off one of the shelves.
As for Survival Mode, I've thought of some additional observations and tips that I'd like to share.
First off, in my last post I said that none of the spells can help you get warm if you're dying from cold. That's not true. If you're really desperate for warmth, you can summon a fire atronach, attack it a few times so it becomes hostile, and stand next to it to make it warm you up with its damaging flames while it attacks you. However, it takes a rather long time to warm up this way, and it's just not a fun way to spend your time, especially because you need to do it pretty frequently in colder climates.
Second, if you're building a Hearthfire homestead, I recommend you get a kitchen. The kitchen has an oven that has unique recipes for baking pastries, many of which are useful foods to mass-produce in order to stave off hunger. Most of these recipes use flour, which you can produce at a grain mill (which you can build at Heljarchen Hall), from wheat that you can grow in your garden and greenhouse.
Third, I've come across a bug that makes freezing water no longer cause damage. I'm not sure what causes it, but it seems to be permanently disabled in my recent saves. Not that big of a deal, but I thought it was worth mentioning.
Finally, there is a mod on Nexus called
Lenient Survival. This mod includes a component that makes the Flame Cloak spell warm you up while it's active. I think this is a great and necessary addition, as that spell already protects you against icy water, so it makes logical sense that it would also stave off cold from air you come into contact with. However, I think that most of the other changes in that mod make Survival Mode a little
too lenient, like the component that removes the attack speed penalty from hunger entirely.
So here's what I've done: I've made a personal edit of the Lenient Survival plugin that removes most of the changes, and only keeps the Flame Cloak change and the vampire changes (which seem to make sense to me, even though I've yet to play a vampire in Survival Mode). And while I was at it, I've added a few changes of my own for things that bothered me, things that I found too unrealistic. Most of my changes are aimed at making the penalties for hunger, cold and exhaustion less suddenly drastic, and more gradual.
For example, the first tier hunger penalty, called "peckish", is a debilitating condition that makes your attacks 30% slower, and your blocking and sneaking 30% less effective. This makes no sense to me, because when I'm peckish in real life, it's not some debilitating condition that makes me unable to do things. And even from a gameplay perspective, I don't think peckish should be a huge penalty, because it serves as your first warning for hunger. It's supposed to let you know that you will experience harsher penalties if you don't eat something soon. So in order to fix this, I've removed the attack speed penalty from peckish and lowered the block and sneak penalties from 30% to 10%. Then, I've edited the other hunger tiers and made the penalties, including the attack speed penalty, increase more gradually, so that the jump between the new first tier and the other tiers makes more sense. The final tier remains the same it was. I've also done this for cold and exhaustion, where the first tier is less harsh and serves more as a warning, while the other tiers increase the penalties more gradually.
My other change is that I increased the amount of hunger restored by tiny and small food items, as these foods restored an unrealistically small amount. It shouldn't take 500 carrots or 55 loafs of bread to get you from starvation to being well fed, that's absurd. I've increased the tiny food hunger value from 2 to 8, and the small one from 18 to 62. This way, tiny foods like butter and carrots still remain rather useless, although not completely useless, and small foods like apples and bread will actually put a small dent into your hunger. Medium (220) and large (380) foods remain unchanged. In case you're wondering, the hunger scale goes from 0 (well fed) to 1000 (starving).
If anyone wants to use my version of the Lenient Survival mod, I'll attach it to this post. I've named it AdulsSurvivalTweaks.esp.
So far my favorite CC mods are Survival Mode and Plague of the Dead. Even though they have their issues or may not offer as much as I'd like, they certainly make the game more fun for me, so I do recommend these. I'll also give a lukewarm recommendation for Arcane Accessories and the Arcane Archer Pack, because these may not offer much, but more options for archers and spellcasters are always welcome.
As for the other mods I've played, I can't really recommend those. I guess grab them only if you're interested in the items, or if you're like me and want to have the full Bethesda-approved package.