I have a 2011 CRV 4WD as a work vehicle. I think it's been the best-selling compact SUV for 10+ years. It's been great for reliability. Build quality is good (but pretty much everything is these days). The 4WD system with snow tires doesn't really bother me at all. It's not an Audi quattro, but it's fine. That's the good news.
The problem is it is underpowered and has, quite possibly, the most horrid transmission shift mapping and gearing in the history of motorized vehicles. It's the only vehicle I've owned since a VW bug that requires the throttle on the floor frequently during normal driving. With the A/C on, the car can be dangerously underpowered. The throttle travel needed to maintain a constant speed on the highway is horrible and requires 120% focus. If there is over a 1 MPH headwind and anything over a 1% grade? Good luck. It will hunt between 4th and 5th (and sometimes 3rd) repeatedly. There's no manual 4th which would have gone a long ways toward making it driveable on the highway. Only a manual 3rd. Actually, if you drive it in 3rd on the highway at about 5000-6000 RPMs, it is sort of fun to drive and actually has some throttle response
I use cruise control whenever I can, even in the city, and I generally hate cruise control. MPG is not good for a small vehicle, if that is a factor. It's only a few MPG better than my '14 Ram Cummins dually!!
I can't imagine how bad the driveability of this vehicle would be with oversize tires.
While I had the CRV in for 3 months waiting for the Takata air bag recall, I was given a Jeep Compass with the CVT transmission that most people hate. Guess what? I liked the engine/trans combo in that car 10 times better than the CRV.
I'd take a long test drive in a CRV before you decide and see if you can live with it.