I have a 2018 CRV 2.0 auto. I do about 5-6K per year. I was aware of the fuel consumption issue but with the low mileage I felt for me personally it wasn't an issue. Most my driving is urban and relatively short distance. I currently average 29 - 30 mpg around town. It may not be the quickest but again for me I find it definitely adequate for my style of driving. Reliability and comfort are good. As a Honda owner for some 20 years I am probably biased, the CRV is an easy vehicle to drive, and the driving position I find is excellent, and I have had no problem in the last 3 years with reliability. One thing with my 2018 model is the infotainment / satnav screen, it's a bit dated, easy enough to use but is in need of updating.
I hope this has been of some help to you.