Proposal Spots in Manhattan/Brooklyn/Queens??

Hey all! I'm planning to propose this October (probably mid-October). I'm after a spot that's intimate and private but still pretty and city-esque (I love NYC and want that to come through). A few things I'm hoping for:

• Somewhere that photographs well with fall foliage / autumn color if outdoors. (Indoor locations are fine too!)
• It'll be on a Saturday, so ideally a spot that's calm and not mobbed on weekends
• Open to places that can be booked out or reserved privately; happy to pay for a little exclusivity
• Ideally in Manhattan, Queens (near Astoria/LIC), or Brooklyn

Hidden gardens, rooftops, cozy museum spaces I'm open to all recs. Thanks so much!