Depends.
I live only a couple of miles from the 200 mile long crushed limestone KATY trail. This year, they added a paved connection to a popular park. I ride both on occasion. Sometimes I also load my bike onto the car and drive a ways to ride some rural roads. I like that too. I'm not crazy about riding urban streets so I avoid them whenever I can. To me, each environment has it's place and each has it's own set of individual drawbacks. The only problem comes if you try to make one into the other.
I think that if I had to "marry" myself for life to one and forever foresake all others, I'd pick the rural roads.