I find some of these utilitarian railroad trestles across rivers quite satisfying.
Lancefield East angles across a shoal in the French Broad River.  Keep going on this and you’ll leave Cocke County TN and hit Madison County NC in just a few miles. The trestle is 960′ long, with a handy walkway provided.  I’ve been on a walkway similar to this when a train came by.  I was safe enough, but that much power and sheer tonnage was certainly impressive.  And loud.