Tons of lookout points. Most well known is Mount Washington. Looks right over the point. Tons of photography on this subreddit. Check out some of their views as well. I personally love a nice stroll around Highland Park Reservoir. Schenley Park also has some beautiful overlooks on to Oakland with fall foliage.