I'm very new to the motorcycle scene and especially the CX500, being my first motorcycle. As such please take my advice/comment "with a grain of salt" if you will. I can get fairly technical so if you're not a fan of that just skip to the end of this post.
For the majority of the last 10 years I've been very involved in automobile tuning and I'm sure a lot of the theories can be applied here as well. For instance, the misconception of back pressure. No amount of back pressure is acceptable if more HP is your goal. I'm sure we're all in agreement that the more fuel and air your engine can convert into kinetic energy the more HP you'll have. So more air and more fuel going in is obvious but we often forget that all that stuff needs to come out as well. Sticking a big ol pipe on there will do nothing for performance generally with naturally aspirated engines like mine. It's all about exhaust velocity. How fast can you get that hot air out so that it doesn't stay in there and block the new hot air that's coming. When you have a large pipe your high pressure exhaust pulse leaving the cylinder meets cooler stagnant air and expands, slowing it down and often stopping it in it's tracks until it's "pushed" by the next pulse. Resisting the flow a.k.a back pressure. No good!
What you want is a smaller pipe that will be able to maintain the exhaust velocity as it's heat is dissipated. Since cooler air does not expand as fast and therefore moves slower through the conduit, we want it to be ejected before it loses too much velocity. However, making a conduit smaller has a drawback of allowing less volume to be able to pass. Take a garden hose without nozzle, press the opening and the hose tenses and water shoots out at high velocity. But so you know the same amount or even less water will flow due to the restriction. This is because water can not be compressed to the extent that air can. It's a bad example but point made, hopefully. Needless to say that is will mean that the pipes need to be sized for a particular volume / flow so it would work at it's peak efficiency for that application. I.e. Tuned to "ride around town shifting at 5.5k RPM" pipes are a lot different from "Track burning 10k RPM type" pipes. It's nice to have a café racer but if you're not going to race with it don't tune it for racing.
Then there's something called exhaust scavenging. If you will, please think of the exhaust pulse as a wave compression of air, exactly like a sound wave. There is an area of high pressure sandwiched by low pressure, traveling in a certain direction. So now you have hot air that's pushed out of the chamber by the piston on the exhaust stroke. It enters the exhaust manifold / pipe as the valve shuts. Now you have that low pressure vacuum behind that exhaust pulse. Honda engineers have sized the piping and cam lift durations to synch that micro vacuum with TDC (both intake and exhaust valves cracked open). In turn allowing the pulling of intake air into the cylinder before the piston has started it's downward assent. A earlier onset of intake makes for more air/fuel volume to be taken in then if the piston alone would have create the vacuum.
Another side benefit of exhaust scavenging is that when hooked up to other cylinders (The H pipe) the exhaust pulse of one cylinder will create the vacuum to help pull the exhaust of the other cylinder. The end result is higher exhaust velocity, more air through.
So in summary, Honda engineers get paid good money to tune the Cx500 for max efficiency as a go around town type of vehicle with a little headroom for spirited riding and to mess with it will throw off the carefully calculated equation. If you still want to make changes or just want enough power to get by, do all the mods you want but plan on making up your own equation. (Carb Rejetting/modification, Cam/Crank profiling, Engine internal mods, Dyno, new exhaust/header/muffler, running pure xylene with 13.962:1 compression ratio, Hoosier slicks, frame mods, etc...) Google exhaust scavenging and you'll find endless volumes of reading on exhaust theory. Well, cheers and fair winds at your back!