Big fan of Hondas . . . mostly due to their stellar reliability . . . but when it comes to creature comforts and bang for the buck when it comes to features they are not the best. I really think Hondas best selling attribute is that they hold up well in the long term and as such there are a lot of them still out there (heck, I still see folks riding Honda 3 Wheelers from the 1980s). However, when stacked up against other makes they are lacking some of the nice features or you end up paying more for those "extras" (although one could argue that "extras" like disc brakes which are now on most every make and model out there aren't really "extras" any longer . . . and Honda should pay notice.)
In any case I have owned two Hondas. A TRX300 which is the fore-runner to the Rancher which even with only 300 cc of power did a fine job of hauling stuff, plowing and trail riding. It had a hard life as I bought it second hand from my brother. When I sold it the engine still purred, but the rest of it was in pretty tough shape with ripped plastic, shot brakes, the electrical system was shot, etc. . . . then again I know for a fact my brother had submerged it in mud so deep that only the seat, racks and handlebars were still above the mud, he had it floating down a stream a few times, etc.
My "new" ATV is a 2000 Foreman . . . or maybe it's a 2002 . . . I can never remember. In any case, it's the work-horse of the Honda line up along with the Rubicon. It's very much a no-frills machine with straight axle, traditional transmission and a low center of gravity. I use this for hauling wood, trail work, plowing snow, etc. I love this machine . . . but that said, it's not the most powerful, does not have a lot of nice features and is probably one of the worse ATVs for trail riding if you value comfort.
If you really are looking at the Honda line up (and I like 'em, but I would suggest you also compare other makes and models as there are many others out there that are also very good) . . . I would suggest you stick with one of two ATVs if you are predominantly looking at trail riding with some "light" work (i.e. plowing, hauling firewood, etc) -- the Rincon or Rnacher AT.
Only two ATVs now offer independent rear suspension which is the cat's meow when it comes to trail riding -- the Rincon (largest ATV) and the Rancher AT. The Rincon has a 675 cc engine and is the top dog of the Honda line up with some of the nice features that have long been found on less expensive and smaller (or larger) engined competitor ATVs . . . price tag is $9,200 MSRP. Yikes.
Again . . . focusing only on the Honda line up if you go this route (and again, I would personally check other dealerships too) . . . I might suggest the Rancher AT for you as a good trail riding machine. It offers a truly automatic transmission (most Hondas either use a push button (ES) method to shift up or down or a foot shifter -- this is not hard to use, but most other ATVs are truly automatic where you simply use the thumb throttle to go faster or slower so there is a bit of a learning curve to knowing when to shift. It's not hard, but it isn't as simple as other makes/models whereas the Rancher ATV does have a true automatic transmission where you give it gas to go without shifting.
The base line Rancher with 4WD is $6,150 . . . but you're not getting the plusher suspension, power steering and other goodies that make it nice for trail riding. For all this you would need to step up to the Rancher AT at $7,800 . . . $7,100 if you could do without the power steering.
As a comparison . . . a Yamaha Grizzly 450 with similar features as the AT would go for $7,500 . . . if you went without the power steering it would be $6,900 . . . and if you dropped down to the smaller sized Big Bear 400 (386 cc engine), but still wanted the nice ride, automatic transmission and selectable 2WD/4WD it would be $6,600. A Polaris Sportsman 400 (455 cc engine) with everything but power steering is $6,500.