Long Island City - Trendy up and coming community. Oddly enough, thats where the "sex den" is. How convenient for you.
Astoria, tacky, low rent neighborhood. Oddly enough, thats where the gay porn Movie house is. How convenient for you.
I much prefer Forest Hills Gardens. Rich, old world classy. Near the tennis stadium...
but if you want city views, your best bet is Long Island City, but you should go see it first. I dont think it suits a man of your self-proclaimed Status....