I disliked the Thieves Guild for that reason, but... Their big quest is pretty much about restoring their glory. It wasn't amazing, but I liked it.
My first character actually walked away though because
He was already sworn to Hircine, so couldn't justify taking the oath.
I also kinda liked the Companions quests, probably because of the
Reluctant daedra worshiper who wanted out
That was an interesting twist.
Yeah the quests were mostly "go here kill enemies", but only in the sense that *every* quest is mostly that. With the exception of the shitty random thieves guild quests. Heck the thieves guild main quests were mostly "Go here kill spiders/draugr", if you want to ignore the context that way.
Frankly I enjoyed Oblivion's mage and thief quests more though. In Skyrim they really don't have much justification for making you archmage, I think you should have to complete the mastery subquests for the various schools (like finding the invisible things for Illusion). In Oblivion it was longer and more interesting to *join* the freakin guild, because it took you to every city and had a unique local quest. Being able to choose the order was cool too.
As for the Necromancy thing, I agree lore-wise that Traven was probably in the wrong, but that just makes Mannimarco a more interesting villain. He's still a villain though, and the necromancers we meet are mass-producing black soul gems and experimenting on sentients. Traven is probably largely to blame, but the ones we meet are pretty evil. Would have been nice to be able to rescind the ban, though, particularly since the PC is likely to be using black soul gems themself. Anyway, Traven was an idiot and you earn the archmage position fair.
Meanwhile the Thieves Guild quest was a bunch of neat heists, like it ought to be, particularly the last one. The loot was unique and taking up the... mantle of leadership made sense.
Was there a fighters guild? Fighting sucked in Oblivion, never liked it, 880 cast spells erry day (after stealth archery of course). Too bad magic sucked a fat nerf in Skyrim, looks completely absurd to be blasting a guy with fire and doing basically nothing. Whereas archery, alchemy, enchanting, and smithing are each OP as hell. And largely multiplicative.
Lastly, I hate the stupid ridiculous random quests for the thieves guild. "Stealing" from a store means walking in, walking past the owner into their "private" rooms, doing whatever, and leaving. If they even follow you or get mad eventually, I never noticed. I had more issues trying to turn in a quest to a guy who was asleep (I was trying to return his child, and all he'd do is keep shouting at me to leave. Then tried to punch me to death).
By comparison I *loved* "Steal this much stuff to advance our trust of you." It meant I could pick my own targets. Burgling rich people houses *because they were rich and I wanted their stuff* was my favorite part of the game. Looting shops was easier but didn't feel as cool, and I got a choice dangit!
The "Loot x value from hold y" would replace that, with the benefit of being repeatable... except the requirements are so piss-low that I basically loot half an average home and I'm done :/ I could probably sell a single one of my OP potions then pickpocket it and be done (if I ever bothered to level pickpocket in Skyrim, which I didn't).
Oblivion had a lot of issues, but I feel like the thieving was a lot better. Kinda want to go back and see. Just need to craft a 1-second 100-charm so the guards can never arrest me
... which means completing the mage guild entry quests, shit