Redwoods are impressive, but I'm not exactly sure a trunk passing out of the photo is the peak of tree aesthetics. I'd imagine the northeast or the northwest or parts of the south have the strongest claims.
Still, I find something exquisite in the eastern hardwoods, beech in particular. The turning of color and dropping all the leaves is really gorgeous.
Also Douglass fir is nearly as large & long lived as redwood, tho less impressive in person.