I've had eczema my whole life. As a kid, it was pretty severe. I have always hated Eucerin products and never understood why pediatricians swear by them. So I'm with your son on that one.
Brands I like:
CeraVe (cream, the lotion is too light)
Cortisone 10 makes an eczema cream in a red tube
Moisturel cream or lotion
Babyganics makes a good eczema cream
Vanicream is really thick - good for very cold weather
For me, Aquaphor has never been great for an eczema rash, but I've used it on DS's dry skin and it's worked well for that.
Of all of these, I'd say Aquaphor and Vanicream are least likely to sting, which I imagine is what your son means when he says it hurts.
Oh, just remembered - in a pinch, I used to use A&D ointment on eczema flare ups and it's pretty effective - it just reeks.
Good luck!