If you stay out of Murray Hill then you shouldn't see a single frat bro in Manhattan because at the end of June all of them are gonna be either down the shore or at a Yankees game.
However it will be tough to find a non touristy hotel on Manhattan that has all of the your wish list items. (upscale hotel with a rooftop bar, good restaurants same block or in building)
If this was a couple years ago I'd say you have to try to NOT find hot women or great restaurants in NYC but a lot of places didn't come back from 2020 or didn't come back with the same hours/days open/menus.
I'm pretty sure
@HCFord1 was the last one on the board to live in NYC so hopefully he will have some advice better than my grumpy old man nostalgic spin zone that the city in 2024 stinks and 2012 it was awesome.