Will a collie or other herding breed be a good choice for my lifestyle ?

Herding dogs like to herd...They should be able to do what their natural instincts tell them to. Look for breeds that are suitable for apartment life. You might end up with a dog that herds you or children all the time.