Yeah, they're great. The idea of them being repulsive is as good an example as we can find of culturally-biased nonsense. (I grew up in the same way you did, but I'm pretty practiced at sincerely rejecting culturally-inherited nonsense once I recognize it).
I've only had a few occasions, had some cricket-flour chocolate-chip cookies, some roasted ants, crickets, and grasshoppers. Mealworms sauteed with veggies is great. I'm not crazy going out of my way to get weird stuff though. I'm waiting for the day we can just go to the supermarket and buy grasshopper burgers or something. Like any food, there's ways to do it well or do it badly, and just like you don't want to eat rotten apples, it's not good food just because it's insects; insects are good food when they're good (the right type, healthy condition, prepared well).