Those truss bridges also have a handsome industrial aesthetic. Incidentally, some of the best-looking bridges are stone and concrete arch bridges, but it appears they are too expensive to build anytime in the near future. Le sigh.
The ugliest type of bridge is the highway girder bridge, like
this example (which is, incidentally, hardly ever used). What a boondoggle...