I agree that manufacturers are being squeezed from all sides, and you can't blame them for designing to pass the tests.
I followed the link to the Equa website and there is a huge amount of data there. I had a quick look at the fuel consumption figures for our cars. The 500X 1.4 petrol was just over 33mpg, the Suzuki S-Cross 1.6 petrol was just over 42mpg. Both figures tally with what we get in our local driving, relatively short journeys but not sitting in queues much. On a long run, our Fiat does over 40, the Suzuki over 50.
Interestingly, the Honest John Real mpg for the Fiat is almost identical to the Equa figure. For the Suzuki, the HJ feedback is a few mpg better.
All in all, for mpg the Equa site seems to give a good indication of what owners can expect in less than ideal conditions. I haven't waded through the emissions stuff yet!