I like the Mazda 3 hatch best of all you mentioned, but my likes may be completely different from yours.
My needs would send me towards the CX-5, but I highly recommend you look at the Escape and Terrain, if that's your genre.
CX-5 is my favorite. It will fit my need for a new vehicle to go to work and go kayaking (hobby). Did look at the Explorer and it was my main target before starting the research. But it is a bit pricey for the things you get on it and the residual value is not something to be excited about. Did not look at the Terrain because did not come even close to the Explorer, CRV, and CX5 in the reviews.
I'd put more faith in personal seat time than reviews. Some perfectly acceptable vehicles are pilloried by the automotive press because the 'tech is old' or it doesn't handle like a slot car. Drive em all and see what you like.
Remember, you may not be after cutting edge or 10/10s handling. Heck, a used Equinox or Traverse may be perfect for you.