On the Dinosaur Trail, the Orkney Lookout has a stunning view of Alberta's Badlands and the Red Deer River during the day or night.
Timelapse video here: https://vimeo.com/241321303