Skyrim had a ton of quests, but I'd rather see fewer of them. Not because I don't like quests, but because they feel like they're holding my hand. I like having a really long term objective and then it's up to me to figure out the intermediate steps without any arrow pointing the way.
Well I think that's not the same was wanting fewer quests, but wanting less hand-holding in the quests. For example, I wouldn't mind if quests didn't always give map-markers telling you exactly where to go. Or maybe the markers could be more vague, like a shading on the map showing an area, or instructions like "Head to this town, and then go northeast" and the town is marked, but the location isn't.
Because I agree with you in the sense that, after a while, these games can just turn into "Go wherever the marker points you, have a perfunctory conversation with an NPC, and then go to where the new marker points." I don't like that. However, I do like having a list of missions that I can be doing, and I like a little hand-holding. I don't like spending hours trying to figure out where I'm supposed to go and what I'm supposed to do because the developers made it all unclear, but I do like exploring, finding things, and figuring things out for myself.