I would say that list has a few winners, but mostly is IMHO the weaker set of Matrix's line.
Gun's of August actually is a great operational level wargame that simulates WWI very well. The UI is spartan, but usable, and I am VERY picky about a game's UI being workable. You could do worse than picking it up, and it has only improved with the patching since release.
I am not a fan of the Commander series by Slitherine. I will admit, that I was disenchanted with the WW2 verison, so never played the Napoleonic version, but I trust Jim Cobb's review over at the Wargamer.com. Some will disagree with Jim, but most of his criticisms are valid. I agree with Erik that GG:WaW and AWD are far superior and I enjoy Strategic Command 2 (with W&W expansion) much more. Making History is also a good choice.
I am also not a fan of the SSG series of games - thus Kharkov and Battlefront. This is more personal taste - I find that you don't get a lot of different scenarios for your money with these game and I dislike the very "gamey" aspect of the odds predictor and step system. This is probably more aesthetics than anything - but I always felt that you get pigeon-holed into one battle with these games and that other parts of Matrix's catalog offer more for the same or less money. Just personal opinion.
I did not care at all for Carriers at War - again, I felt like it didn't have bang for the buck and the gameplay is very "hands off."
My suggestions would be -
If you don't own Advanced Tactics then you need to get it, right now! Some will disagree, but I feel it is the best, most elegant system, Matrix has. It contains some of the same type of gameplay as the SSG games, but done in a way that is vibrant, more realistic, involved heavy player involvement, and includes an easy to understand but complex supply and reinforcement model. Best yet, AT has a random map generator, like the old Empire games, that will have you playing the game forever! There are also TONS of mods and scenarios (AT has a very easy to use builder) and so you can play anything from a Fantasy World war to WWI, American Civil War, or a modern near-future war. It's the closest thing to The Operational Art of War II in flexibility outside of... well... TOAW II.
Wait for WiF. It will be the grand-daddy of all WWII operational warfare games. I only hope that they don't go the way of Empire in Arms and require too much knowledge of the original boardgame to be able to play. Also, the UI needs to be prioritized, which was a huge downfall to EiA.
CoG:EE is a nice pick for Napoleonics, and Erik rightfully says that the new release is very different from the original. The new simplified economics mode is much easier to grasp and focuses on the awesome turn based hex battles and the grand strategy diplomatics and expansion. Still, it is a complex game, so you might continue to find it overwhelming. It helps to have a knowledge of the Napoleonic era before playing! If you found CoG made your head spin - forget all about Forge of Freedom - it is even MORE complex and requires more micromanagement, despite the fact that it remains the most detailed sim of the ACW that exists.
"Neca eos omnes. Deus suos agnoscet!"
(Kill them all. God will know his own.)
-- Arnaud-Armaury, the Albigensian Crusade