If anyone from HN is visiting Edinburgh for Hogmanay, a great view of the fireworks can be had from the top of Calton Hill in the centre of the city. The best way to get up is the set of steps next to Howies on Regent Road.
Along with putting up boards along Prince's street and now completely blocking off the entire city center with barricades unless you pay to get in, this period seems quite anti-citizen.
Another good spot used to be the Vennel steps beside Heriot's, but it has become a popular Instagram/TikTok spot recently so might be busy.