I played it once, and it was pretty good, if not that memorable hole-to-hole. 5+ years later I don't remember much other than the bridge-dominated 18th.
I feel like where it is (feels very NYC), what it cost to build for better or worse, the nice views at the end, the upscale feel...$265 is not really a fleecing, provided you splurge for golf once in a while for that price.
I'd say it's worth a play, just to see if you hate it as much as you hope, or maybe you'll be surprised.
I get $265 is a big ask "just to see," but that's my take.