Well, I have/had 3 CR-Vs, so here is my experience...
First of all, it seems the CR-V was designed, in my opinion, for older people (or people with back issues). Seriously...the driver seat just seems to be at the perfect height for people to 'slip' into...no climbing or falling in. Getting out is just as easy. Also, those of you have have or had CR-Vs...notice the back doors....opens almost to 90 degrees. Those with kids and child seats can appreciate that as well as older folks with walkers.
On a side note, a vehicle better suited for the older generation (especially those with walkers)...better than the CR-V that they don't make anymore...the Element, which was just a CR-V with a different body. My aunt has one and loves it.
So, had a 2nd Gen CR-V (04-06)...actually a 2.5 Gen (06) EX model with 'real time 4wd'. I had bought it used with about 89k. Had to get this one because it was blue which was hard to find at the time (for wife). I had it until about 212k miles. In the 100k+ miles I had it, I had to replace the A/C compressor clutch, a rear wheel bearing and both front compliance bushings...and of course, wear items like tires, brakes, oil, etc (and the rear diff). We used the hell out of that vehicle...used it like a truck. We made many, many trips to Atlanta...hauling back trunk load of food and stuff. Traded it in at around 212k miles because the check engine light came and stayed on...which ended up being the timing. Again, don't know the history of this CR-V since it was bought used, but when I had it, the oil was changed every 6k miles. But the timing still went out on the thing...you could still drive it, but had no power as the VVT was disabled. I'm suspecting that the original owner when too long on his/her oil changes.
Second CR-V was a 3rd Gen (07-11)...an 08 EX-L again bought used. I have to say, this gen of the CR-V 'felt' the best. I mean it felt SOLID and was so smooth. Going over bumps and rough roads...it felt bigger than it was. We bought this when it had about 60k miles on it and traded it in when it had about 120k miles on it for a truck based SUV (which I needed for work). BUT, I wish I had this CR-V back. Everything about it just felt like 'solid quality'. In the time we had it, only had to replace the tires.
Now we have (wife's car) a 2016 CR-V Touring (4th Gen) that was bought brand new. To me it feels like Honda took a step backwards. Don't get me wrong, the car is nice with all the bells and whistles (except no 4wd) and seems to be put together well, but it seems to have lost something compared to the last generations. For instance, the quality and feel of the interior materials doesn't seem as solid as the '08 we had nor does it feel as rugged as the '06. It feels delicate. The whole car doesn't feel as solid as the '08...it seems louder on the highway, plus when you close the door, you getting a 'tinny' sound instead of a solid 'thump' in the '08. But, so far, nothing has been done except oil and filter/fluid changes. AND I don't care what Honda says...the 2.4L Earth Dreams (with direct injection, non turbo) appears to have some fuel dilution issues. Every time I check the oil it smells like gasoline. So, it gets its oil changed every 5k miles, regardless.
Overall, I think a CR-V would be a good choice. My recommendation would be the 3rd Gen if you can find one or a 4th gen with the normal 2.4L, not the directed injection one...if buying used. Also, if you don't need it, I would stay away from the 'real time 4wd' systems on these vehicles....they require regular maintenance and use a Honda specific fluid.