The good news is more and more cities are catching on and starting to improve bicycle infrastructure.
The bad news is that occasionally it just isn't complete and leaves you in a busy intersection or middle of a lane with no obvious (or safe) place to ride. Even worse is when it is used by construction crews as a place to put signs to help guide traffic "safely" though an area.
Sometimes however, the design of bicycle lanes is compromised by some really odd things. Just for fun someone has taken each example of poor design and done the same thing with roadways for cars..... Suddenly it doesn't seem like something so trivial eh?