What areas in Skyrim always drag you back and just make you gawk? For me it's the road between Riften and Whiterun. The dense pine forests, the high vantage point of Eastmarch's natural springs, magnificent!
Also the College of Winterhold. With my character wrapped up in college robes, with the magical blue lights and the cosiness of the inside, strolling around the place with https://www.youtube.com/watch?v=mvsMn05WtaI in the background. It feels especially homely to me because I've spent most of my life in the South of England and it reminds me of the horribly cold North
Lastly there's Valtheim Towers East of Whiterun. Just a nice structure with a great view from both sides. Can't go wrong!