This is my best-to-worst list at the moment. I'm sooo glad IW shook this title up by overhauling CoD map design.
Listing maps is pointless. As a long time CoD player, the biggest thing I have learned is that it takes all kinds of kinds.
Some love the little maps, others despise them. Some dig huge maps, others hate them. What you think is a horrible map, others may absolutely love. Take Nuketown, for example. Not one of my favorites, I enjoyed it in moderation, but for some reason many were crazy about it.
The key to maps is variety. Not all are going to be to your liking. But good players learn each map, even the ones they hate. They figure out their strategy and eventually learn to have success on all of them. I personally challenge myself to stick with maps I am not fond of. For the first several play sessions, for example, I couldn't stand Siege. Just kept dying from every angle. Today it is not my favorite map still, however I figured out how I need to play it and have done a lot better.
Issue is, people decide they hate certain maps... and quit when they come up in the rotation, adding to the already complex issue of Match-making. (CoD Community's sense of entitlement strikes again) Stick out every map in the rotation and you will be all the better for it. Helps prevent burn out on the game as well, when you allow for variety in the rotation.
My main takeaway from your post here is BALANCE. Give me a mix of small hectic maps and large sprawling maps, circular maps and funnel maps, flat maps and vertical maps and I'm a happy camper. BO2 was alot of fun, but it was constant frenetic madness with like 1 or 2 exceptions. I needed more of those exceptions to make it feel like a well-rounded game. To be fair, I only purchased on set of DLC maps, so I may have missed some diversity there.
The reason so many people liked Nuketown was that it was constant action. For better or worse, you couldn't go 10 seconds without a firefight, and usually much less than that.
Balance is a good way to put it.
I don't mind constant action, but I also like the more slow paced matches from time to time as well. They have a certain intensity that is just hard to describe.
Issue is, CoD Players want what THEY want, have no patience for what others may enjoy. They are selfish and thus impact match-making and the overall experience. Enjoyment can be found in pretty much every map... and while I can certainly feel people's pain when I get into awful matches on Maps I am not crazy about, I look at it as a learning/growing experience.