Obviously, drawbridges are much needed feature in the game. While we let the modders figure out how to circumvent that particular conundrum, perhaps we should make do with eyecandy lots.
I think that rail drawbridges would be particularly easy to do. All that is necessary is the general shape of the ingame overdeck truss bridge or level rail bridge and the addition of a large steel tower encasing a concrete block:
(https://www.sc4devotion.com/forums/proxy.php?request=http%3A%2F%2Fwww.historycooperative.org%2Fjournals%2Fsia%2F29.1%2Fimages%2Fdesloges_fig04a.jpg&hash=2d4c17eaedc02237623daaf53601bec627dbe41a)
Heres a pic of the counterweight itself:
(https://www.sc4devotion.com/forums/proxy.php?request=http%3A%2F%2Fi.pbase.com%2Fu49%2Fclements%2Fsmall%2F40856701.S_7453.jpg&hash=76f778b553cd047c5bed45a067f86233b0bc77a5)
Now, add a control turn the BAT into an overhanging bridge for a three or 4-space wide gap tower, and set the bridge addition overhanging from a seawall set, you have a drawbridge that'll always remain closed, but at least it'd look like a bridge.
Perhap's it'd even be possible to set the lot underwater and have it hover over a bridge (at a perscribed elevation). Not sure if that'd work, though.
I'm no BATer at all (or even lot editor, for that matter--my skills are quite rudimentary in the lot editor field), so I can't undertake this project that'd probably make our waterways look snazzier. Mayhap one of you would?
well all i can say is be watching out for Zwabberaar over at ST and SC's as i know hes working on lotting something from CAL_Sg canal set so be watching for that as i know that may or may not fit the bill in what you are looking for... - pat