Cattle Point is not far from where I live and I’ve been there many times. The shoreline faces east, towards the American San Juan islands, so My favorite time is early in the morning at sunrise. It’s also a designated Urban Star Park

https://bcnature.org/vancouver-island-region/uplands-park-cattle-point/

https://www.oakbaytourism.com/stakeholder/uplands-park/

https://rasc.ca/lpa/cattle-point

https://en.wikipedia.org/wiki/Uplands_Park