I did quite a bit of research on them at one point, but went with something else. They are, as others on the thread note, a Pilot / Odyssey with a bed on it. IIRC they come with either 2WD or AWD. I would get the AWD, just because. Their GVW is pretty good as I recall, as is the towing capacity, but as noted throughout this thread, the bed is the size of a saltine cracker.
It ultimately depends on what you want. Dependability, surprisingly good mileage for a truck, good power (Honda 3.5 V6 is strong), good resale (ridiculous resale, IMO), BUT - as others have noted - they aren't selling a lot of them (27,000 last year, IIRC). That's why you don't see a lot of them.
Agreed. They also took a year off between gen 1 and gen 2, that didn't help sales or market penetration. I see a few of them around here. I own a small Honda sedan I use as a commuter vehicle. 3+ years in and I'm very satisfied with it, 45+ MPG and it isn't even a hybrid. I also own a 3/4 ton 4x4 diesel crew-cab pickup. There is no way a Ridgeline could replace our truck.
I look at the Ridgeline (and other similar small pickups) as really SUVs with an open back. ie. they are for people who might normally have a sedan/SUV/minivan but occasionally need to haul stuff that is a bit too bulky or muddy/messy to want to put inside their vehicle. The Chevy Avalanche was more or less the same idea - just larger scale.