One of such bridges in St. Petersburg in Russia is very close to the KGB/FSB regional headquarters (it is 2nd building right from the bridge, totally dominating the surroundings) and 15 years ago, when times in Russia were still softer, prankers drew a large male organ on the bridge right before the bridge was raised https://plucer.livejournal.com/265584.html

According to some sources https://www.drive2.ru/b/288230376151944232/ it was even shortlisted in the national modern art competition. That were the times. Today in Russia even just thinking about it would get you 5 to 10 years for discreditation of the state organs.

Hamburg, .de:

https://de.wikipedia.org/wiki/Kattwykbrücken

https://de.wikipedia.org/wiki/Rethe-Klappbrücke

Initially built as turnable, now stationary:

https://de.wikipedia.org/wiki/Oberhafenbrücke