Sugoi actually means "weird" or "bizarre," and is used in the context of "cool" only by younger generations. This is a bit similar to the gradual change in meaning of English "fantastic" which originally meant "phantasmagoric" (look at the root). Frequently chirped or shrieked in anime, especially if said anime includes lots of adolescent girls.