I had an ACD in a unit in Sydney. Never an issue, nothing was ever destroyed and my place was always clean.
Just because you have seen something horrible once or twice does NOT mean that every one and every thing is like that.
Anyone can own any size dog in an apartment, the individuals ability dictates how well it works not the breed of dog.
Look at New York - majority of dog owners are in apartment blocks and the majority have better socialised and trained animals than those on acreage...