The view of Manhattan varies quite a bit, depending on where you're standing. Some parts are quite plain.
From Williamsburg you see the east side of Manhattan, just below 23rd Street. The tower on the right is the MetLife Building. I took a picture of it here.
Between lower Manhattan and Midtown, the buildings decrease notably in size. Manhattan is built on natural bedrock but geologically some areas are stronger than others.
Neighborhoods are zoned so that skyscrapers are built only in areas that can bear their weight.
Related posts: A View from the Promenade, The View from Downstream and Where the Kids are - Williamsburg, Brooklyn.