fireworks are illegal in my city, but they're legal in neighboring cities so there are stands around. But my parents live on the lake (claim) and everyone on the lake lights them off and the cops don't care or do anything about it. Their neighbor has an actual cannon-- like a war cannon that he lights off-- I don't think it shoots anything I think it gets packed with gun powder and just makes a big boom-- like a quarter stick. Also we've lit off 1/4 sticks, 1/2 sticks and tennis ball bombs and have never heard from the police.
The riskiest thing in our state is buying the illegals (m-80s, sticks, bombs) at the reservation. They've cracked down hardcore, and there are undercover cops everywhere. I don't even really care for these fireworks but my brother has always been into them so I always ride with him to the Res.
Houses not on the lake in my city can sometimes get away with fireworks, too. It's basically unenforced unless someone: starts a fire, gets injured, or the neighbors complain.