I think the observation that it does depend on what you want your daily life and access to be is important. My suggestion is that you rent first, perhaps in the west end of downtown - somewhere central - where some good rentals can be found. And just use your spare time to explore the city as you get settled - hopping across Lion's Gate to check out North Vancouver, hopping across the Burrard St bridge to check out Kits, hopping across Cambie to check out Mt Pleasant, Fairview, and the other places mentioned. Taking Skytrain out to Richmond, Burnaby, etc. Just go hang in various places, and learn how work - and work commute - fits into the scheme of things as well. Figure out the cultural mix of each neighborhood, see how it fits and meshes with your lifestyle.
The other important thing is will you have a car? I like not using the car during the week, but I do have one which changes my perspective I'm sure. I do use it to get out and about on weekends. If I didn't have a car, I'd probably have very different perspectives on what areas would work.
I moved here under 2 years ago and was naturally drawn to downtown, having lived in other downtown areas before for several years. And I do love it - the walking is easy, variety of things to see, central location to check out other areas, etc. However, I'll be the first to say that, with the natural beauty so much a part of the Vancouver experience, I find myself sometimes on the North Shore thinking, "hmmm, maybe taking a ferry over to downtown on occasion instead wouldn't be so bad." It is that nice and that much closer to the mountains and hiking. I was in Deep Cove a few weeks ago, which I had never discovered until recently. And even there they had plenty of daily restaurants, shops, and groceries to take care of my need to feel I'm in a walkable community. From that community specifically, you would probably need a car, though there is bus service. But my point being is it was completely different from downtown yet still within relatively easy access . . . it felt almost like island living but without having to catch a ferry
, which has a definite appeal to me these days.
I hasten to add that one of my favorite things about living in downtown Vancouver is that you can live a downtown experience yet get out of town within 20 minutes typically - barring back-ups on the bridges, which I've learned to avoid for the relatively short time each day when it's a problem.
I've never experienced the ability to escape the city so easily - from downtown to wilderness in less than an hour on any given day. That's pretty remarkable, and one of the big draws of the city.
My main point is just don't think you have to pinpoint a precise place before you make your move. See if there are options to give you a few months or a couple of seasons to see what really gels with your lifestyle - and realize your lifestyle could change as a result of being here. I know mine did.