I think there is a need for both multi-use or off-street bike paths but also a need to continue with the old school bike lanes on roads. Personally, I prefer riding on the road (in most cases). I'm a road cyclist and want to go far and fast. I obey the rules and am respectful to the cars. But I choose my routes smartly. I'm comfortable on King Edward, for example with the cars, but can never understand people who ride along Broadway (especially since there is a bike route a block away).
I choose my road routes based on shoulder width and then bike lanes. I don't get much from the bike lane on 49th from Cambie to Oak, but I appreciate its' place. But what is silly is beyond Oak west and Cambie East, there is no bike lane... so why bother putting one in for just a short distance. I also take advantage of the City's extensive bike routes and keep off the major North/South roads.
As for bike paths, I definitely make use of them around major interchanges and bridges, and appreciate when there is a safe non-car area to go to access key points along a busy route. I get that I need to slow down and be mindful of other users, but not all cyclists do. And there in lies the potential conflict.
I was pleased that Richmond kept the bike lanes along Railway when they constructed the new shared-use path on the old rail ROW, for example. but can't figure out the path they built east of 4 road on River Drive. A big wide path that dips at every driveway and the road it self has no shoulders... forces most bikes to ride with the cars (because who wants to risk riding over so many driveways that dip every few feet), rather than making a wider shoulder and keeping the sidewalk for pedestrians. Imagine if they paved the dyke in that section... would be much nicer instead of a wide sidewalk in front of peoples homes. Plus, the path ends abruptly forcing cyclists and pedestrians back onto the street anyways.
Basically it comes down cities planning the routes and recognizing there are different types of cyclists, and that there is a benefit to keeping the cyclists of varied groups separated from each other. eg. Road cyclists on the road, yet on a safe shoulder or bike lane, and the families and kids and casual cyclists a space they can ride and feel safe away from both cars and us crazy roadies.