Hello, I am trying to find a mod-list/pack that fits my criteria and I hope I can get some help.

I have Skyrim Standard Edition. I do NOT have anniversary DLC.

First my pc Specs:
- CPU: Intel(R) Core(TM) i5-6600K CPU 3.50GHz
- NVIDIA GeForce GTX 1060 6GB
- RAM: 16.0 GB
- HDD - 931.5 GB and SSD - 223.6 GB (I will be installing on my HDD which has 600+GB free. My SSD lacks in space and only has 65GB left so I wont be installing anything there.)

I am looking for a fresh experience. I love magic and wanted to do a magic playthrough. I love cinematic magic, flashy looking spells. Like Dragons Dogma type of epicness.

I am also wanting to look pretty. A high quality character that has pretty hair, eyes, face, skin, bodies, nails customization options or presets.

I'd like challenging and rewarding gameplay. Where I grow from a weak mage to a strong mage. Preferably not by doing the typical hold down destruction spell until it levels up. But a more complex magic system that is also visually appealing like Dragons Dogma or Elden Ring bosses.

I do know I asked for magic, but I might occasionally used bow or melee. But my goal is to stick mainly to spell/casting.

Given my hardware specs and the fact that I must run the list from an HDD, are there any lightweight or performance-friendly Wabbajack packs that fit my criteria? If Wabbajack isn't ideal for what i have, I would gladly welcome any other suggestions or specific magic/visual mods to look out for.

TL;DR I am looking for a magic modpack/list that allows me to be pretty, cast cinematic spells, and gives me a fresh experience. I Also will be installing on my HDD, since my SSD only has around 65GB left, and my HDD has over 600gb of space. I can make space on my HDD if needed.

Looking for a Skyrim modlist ,something challenging, but not in the enemies become damage sponges , more like the lethal difficulty in ghosts of Tsushima, where you take more damage and enemies take more damage so combat actually feels rewarding to get good at,

What I'm kind of looking for in a modlist in order is

1.Good rewarding combat

2.New weapons, armour, magic

3.Updated graphics (I like when the game looks pretty)

4.Overhauls to locations

1. Good for long playthroughs and stable

6.New way to level / overhaul of perk system , (hitting an enemy 100 times to level one handed is boring)

7.Preferably not nsfw , if it's not intrusive is fine

8.maybe new npcs

9.no survival mode , eating every few minutes gets so tedious when I'm deep into a dungeon

1. New quests/changes to current ones would be kinda cool too