I suppose a better answer would be Thurso/Wick - two rather functional towns set in scenery which is relatively bland for the Highlands. You would imagine the Far North Line would come to a dramatic end than that!
I see what you mean, but you're referring to the towns and the scenery rather than the end of the line, and even then to dismiss the scenery of Caithness as 'bland' is to misunderstand it. It might not be mountainous, but there are long sandy bays, high cliffs and the Flow Country.
Both Thurso and Wick still have their compact but attractive original station buildings which more than do justice to hours of mostly ancient single line jointed track. So, on the contrary, I think that the stations are fitting ends of the line for the route they're on.
Going to the absolute opposite corner of Scotland, Stranraer Harbour has got to be the most irrelevant and wretched arrival point even allowing for its route being relatively minor. To have a station physically remote from its town because it serves a harbour that no longer receives ferries is like some sort of cruel joke.
And, sadly, staying in this corner of the country, the present condition of Ayr station, the end of the line for so many fast trains from Glasgow, is desperate.
Finally, and to be positive on Ayrshire and the Clyde, a nomination for a station at the opposite extreme - a beautiful arrival point punching way above the weight above the route serving it: Wemyss Bay.