It is tough but there are places you can find which do offer great views.
I love going to BDL since that offers a great view...especially to the west and north.
In West Hartford there was this golf course I would go to which offered great views to the west and north as well.
I usually try to find open fields, parking lots, or like remote farmland areas.