IMHO, unfortunately it isn't cut and dried as saying "avoid these states or these regions because every one there is anti-gay" or "these places are 100% safe". You find acceptance and hatred everyone to differing degrees. However, I think you are safer in most larger coastal cities (NYC, Boston, LA, San Francisco, Portland Seattle) plus places like Chicago or Denver.
Of course, YMMV