I owned a 4-cyl Accord (one before previous gen) before getting the CX-5. I did like the car very much, though the trunk was not as usable as a CX-5. It drove very nicely, though the brakes could have been better. I liked the 5-speed AT, as it was almost always doing exactly what was needed. Back seat was more comfortable. Infotainment was AM/FM radio and CD player

.
The CX-5 is a compromise vehicle for me. It has AWD, which is very important to me, higher ground clearance, very good utility and same fuel-economy as the Accord. It handles best for its class and ride quality is pretty good, slightly stiff, which is better than spongy for me. The transmission resists downshifts, which is sometimes annoying, but is otherwise very good.
I
do not prefer the higher seating position which implies increased fuel consumption, increased weight, higher center of gravity and reduced handling capability. If a 6 Wagon AWD was available in the US, I would buy one today.
The Accord V6 is pretty quick and has the best fuel-economy of any V6 sold today, I believe. Despite that, you could probably get better MPG on a CX-5. It has no AWD and the trunk is less useful. I did not drive it, but believe it would have better handling and have better noise isolation and better back seat.