I don't believe you will ever find anywhere that is without some sort of problem.
My husband was raised in Astoria and we still own the two-family. Since the 1950's, we had one break in. We as homeowners, not Realtors, have always loved the area and have never thought of selling.
You have to be comfortable with where you move...One place may be comfortable for me, but you may hate it. Please make your own decisions after making your own investigations.
Move out when you have kids. Its just too much like cramped like Manhatten for kids, with fewer parks.