Of course, this rarely happens, more precisely depending on luck. However, sports betting certainly requires prior research on the team we will choose, we can't just place crazy bets on any team we will bet on. Unless both teams are equally strong, it is possible to place a big bet because the winning result depends entirely on luck.
The crazy bets like Op said have big odds but would hardly play as predicted. A friend once mentioned to me that he placed a bet on his team to make the first throw-in and to his surprise they never had an opportunity for that till almost the end of first half. So, the crazy bets probably pays out big but the chances of winning are not there.
The winning chance is indeed usually low. Thus, we call it crazy bets for many reasons. But gamblers want some adrenaline rush and excitement, hence, placing bets on this kind odds. You can really be agitated watching the game if you have placed those kind of bets. However, for me, if you are quite not having so much funds to spare, better use small amount as the chance of winning is not very good.