I am looking for SCI-FI novels(fan-fiction included like Star Craft) and novels where the NC gains/has necromancer magics/powers.
Both Fallen Monarch and Holy Emperors Grandson is a Necromancer are novels that fit what you're looking for. They take place in a shared universe but they're separate stories. Theres also stuff like Solo Leveling, Seoul Stations Necromancer, and a slew of other Korean novels whose MCs have necromancer powers.
I'm sure it'll be back up soon, as I heard it was getting officially licensed. Luckily Fallen Monarch is still being worked on.
And they're both necromancer novels, so they fit what OP was asking for. Theyre both fairly new and one is still being TLed while the other should return soon. That's why I also included some completed novels afterward as well. Don't really understand how giving OP exactly what he wanted makes me "brain damged", but whatever floats your boat, dude.