First of all, the example you just gave concerning your riding clearly shows the major political problems that this could pose.
Then, of course, there's the cost risk. You have to choose a project that will both maximize the return on the financial investment and bring about real changes in user behaviour. That's where the exercise is extremely important. I dare say it's one of the main challenges.