[...]
On the New York scene I mainly hear about Society and Amsterdam but there has to be others.
[...]
Yup, there's plenty -- it's NY afterall.
In my area, there's Jack-n-Jills Billiard Cafe in Brewster, NY. This room dates to the early 1960s, and is a true poolroom -- signed pictures and memorabilia all over the walls. About 14 Gold Crown 1s (yep -- original GC-1s with the white metal skirts), with a Søren Søgaard 3-cushion table dating to that same period. And all the action you could possibly want -- it's an action-lover's haven.
Also, a recent new room that is both traditional and trendy is Eddie Locke's room in New Milford, CT -- "Fast Eddie's":
http://fasteddiesbilliardcafe.com/ Impeccably-maintained Gold Crown IIIs (the Joss tour stops here, and Eddie himself is a meticulous table mechanic), a Verhoeven 3-cushion table, and a darts area round it out. Sure, there's a trendy side to this room (a room owner has to do what a room owner's got to do), but there's good pool action here -- and in all games, not just rotation games.
There's also Iron Willies in Yorktown Heights, NY, as well:
http://ironwilliesbilliards.com/
Not as much action here, but there's a couple very good 3-cushion players, and if you're looking for stout 14.1 or one pocket competition on a very nice Diamond (with the One Pocket ball-routing-collection diverter accessory), you can always call on moi.
-Sean