I too loathe sustrans, the one flattering thing I can think of saying about them is that plenty of other things waste vaste amounts of money but at least this is in the name of cycling.
To be fair on connect2 there are 2 schemes near me, a reserve scheme near sheffied city centre which would be highly beneficial to me. There is a need, unfortunately the problem arises in the first place because Sheffield City Council are forever tearing up sheffield and introducing new one way systems, blocks, the tram etc and bikes have been left out completely. The scheme is dumb though because in the real world if you were that bothered you could illegally hop over the tram bridge and I can't really condemn this as it's not just cyclists that do it but city of sheffield workers and tram related people taking a shortcut home or lard-arsed layabouts who can't be bothered to park somewhere half sane and walk. In the real world either party that doesn't feel that strongly about it does that.
The other scheme that is on the list of 79 is nearby but I'm not sure whether everything on the map is new certainly some of it is existing cycle network. If it is then it'd be reasonably impressive as it deals with real problems like crossing the M1 and converting a footpath into a cycle path. The scheme highlighted in red would be the only crossing between 2 main roads 2 miles apart of a canal and a railway line so there certainly is a case for the scheme but I think to be honest the Sheffield City centre one would be more useful to more people.