I can only think of a single real bicycle/pedestrian tunnel, which is the Maastunnel in Rotterdam. Incidentally it is also one of the oldest tunnels in the country. It was recently renovated and is actually really pleasant to cycle through, because motorised traffic uses a separate tunnel tube.
As for turns in underpasses, at complex junctions or infrastructural elements it may be tempting to just make a small bend so that the underpass is cheaper to build or easier to fit in to the environment. Take these crossroads for example: https://goo.gl/maps/21Yqj89WwyiiuZfD9. If you look closely you will see a bicycle tunnel going underneath from the southwest to the northeast. This important connection for the residents southwest of the shopping center is relatively long and has a slight bend. This makes it feel dark and unsafe to the people who use it.
A better design can be found at this roundabout: https://goo.gl/maps/TXuFjXj85huufc7m6. Because the middle section is open, all of the individual underpasses are short and there is a lot of daylight, making cycling there safer and more pleasant.
Here in Italy (where we have lots of mountains and conversely tunnels) the distiction between tunnel and underpass (or overpass) is neat, we also have (though not extremely common) distinctions betweeen different kinds of tunnels (Galleria):
But I don't think I ever used this word... I'd say tunnel I guess.
> Tunnels have a smaller height difference than bridges. Only need clearance for the height of a cyclist, not for trucks or trains plus electric lines.
> The article is actually about underpasses, which are not "tunnels" but rather a bridge (or overpass) built on the "other" road.
In the case of the Maas Tunnel in Rotterdam there is a second tunnel for combustion vehicles. Pedestrians have a tunnel of their own below the cycle tunnel.
The large detours of the bike path at both ends of the tunnel are also a bit annoying as they significantly increase the distance you have to cycle. The alternative with elevators like in the Sint Annatunnel isn't really better though, because there you just have to wait for a long time for the elevator.
I much prefer bridges but where I've used bike bridges (like in Nantes) they were very low with little clearance above water. Even in Lille they're just a few meters, maybe ten meters at most, above water, so they're easy to climb without a large detour.
I wouldn't take the Pont de Cheviré on a bike for example...
Clearly for crossing any lengthy stretch of water, a bridge is much preferable to a tunnel.
Usage of the "tunnels" word got me confused through the first half of the article, until it showed a photo of an underpassage in the Netherlands.
Now that you mention it, it does seem strange that the article doesn't mention turns before/after tunnels as those tend to lead to risk taking (going too fast into the underpass that you can't see into).
At least in Finland the underpasses used by cyclists are also used by pedestrians, so the underpasses being used as mugging spots is conceivable, although I've never heard about it happening.
A design that is safe, but makes “the people” think it is dangerous is a failed design, as fewer people would use it.
And hey, there's no car traffic, so accidents are likely to be at least a little milder, though hitting one of those stone pillars is perhaps not much better.
Such "tunnels" are normally very short and straight, so I cannot understand the reference to turns in the article, a "real" tunnel is several tens of meters, more often hundreds or thousands meters long and very likely is not straight, though I doubt that they are the preferred hideout for mugglers aiming at cyclists.