What's a good adventure type motor bike for 2 people to ride together, HONDA's nc700x? Anything better?

Purpose is to ride around the bay area in san fran and take adventure rides to places like CANADA or Mexico (maybe)…

It can be but there are also many other very good bikes in that segment such as the Suzuki V-Strom 650 and the Kawasaki Versys 650.

There are dozens of ADV bikes. Personally, I don't want to ride a 600 pound dirt bike.

Jay P mentioned the V-Strom 650 which is a nice bike but I would not want to ride 2-up on one for too long. The V-Strom also comes in a 1000cc model which is better suited for 2-up riding.

KTM and BMW make the best adventure bikes if you want some real off-road ability. Yamaha's Tenere might be worth a punt. Most of the others have the look, but would faint on a gravel path.

Of course two smaller bikes would be a better option, especially if you might be miles from anywhere.

Yes