Where was popular sovereignty used with disastrious results?

Kansas.

It was meant to be a sensible, orderly system of local voting on the slavery issue.

It turned out the opposite - terrorists from both sides crossing into the state to intimidate voters and cause chaos by declaring all results to be rigged.

People talked about 'Bleeding Kansas'. They were looking at a miniature version of the upcoming civil war.