For canoeing, I just need something old and cheap, but reliable mechanically, low enough not to require a step ladder and Janja Garnbret skills to load boats, and preferably sleepable for a 5'-9" guy.
@Glenn MacGrady, with the above in mind, I think that a Subaru Outback is pretty perfect for you, at least on paper—it's a great canoe vehicle, and great adventure vehicle in general. I have a 2009, and as others have noted, it's long enough to sleep in with the seats folded down (I'm also 5' 9") and low enough that it's easy to load a canoe onto. Plus, with with >8" of ground clearance and a great AWD system, it'll go just about anywhere short of extreme off-road trails—and mine has a stick, so it's even fun to drive!
However...I have been quite disappointed in my Outback's reliability and cost to maintain. My experience has been similar to
@Roybrew's: mine currently has ~195,000 miles, and ever since I hit ~90,000 miles,
something expensive has needed fixing about every 10–20,000 miles, which for me works out to about once a year. Also, even when I've had spans of time where I had a reprieve from major repairs, there have been many little ones (e.g. wheel bearings) in-between whose costs really added up. I absolutely love my Outback and so I keep fixing it, but given how much it costs to keep on the road, I'd be hesitant to buy another Subaru or to recommend one to others.
The above being said, I've heard enough stories of reliable Subarus (including in this thread) that it seems quite possible you could find one that's fairly trouble-free—my experience is just one data point. Also, even if you were to get one as problematic as mine, if you only drive the car a maximum of ~3,000 miles per year, then you could easily go several years between repairs, which you might feel is reliable enough? And there aren't many other cars like the Outback out there, and none of them are any cheaper to keep on the road (as I understand it)...so if you really want a lifted wagon or you really want a Subaru, the Outback is clearly your best choice. Just be sure to watch out for head gasket issues on pre-2010 4-cylinder models (but that goes for all 4-cylinder Subarus, not just the Outback).
You're pretty close to me in CT, so if you'd have any interest in checking out my Outback, I'd be happy to find a time to show it to you—maybe we could meet up for a paddle sometime? My car isn't for sale, but seeing it in-person could give you a feel for its size/shape to help you decide whether the Outback is a model you'd be interested in.