Hi,
There are lots of good spots in NS in Sept. On Brier Island, passerine migration is probably better earlier in the month, and Hawks later, Shorebirds all month. Brier can be very good, and it's well worth going on one of the 1/2 day whale-watching trips for seabirds (and whales). In late Sept. it's a great Hawk watching spot. Brier is not as good as it used to be for shorebirds, but can still be OK (Pond Cove, Westport Harbor). Cape Sable Island is probably the best spot for shorebirds, and can be very good for other migrants too. Depending on the length of your visit, you might want to get Blake Maybank's book, Birding Sites in NS, for advice on other areas. Also check the NS Bird Soc's web site for field trips etc. I think there will be one on Brier. Early in the month I'll probably be there myself, and I can show you around if I am.
Around Halifax, look at Hartlen Point and Duncan's Cove for passerines, and Three-Fathom Harbor, Lawrencetown, Conrad's Beach and Hartlen Point for shorebirds - on a good day, all these spots can be excellent. The NSBS web site has a list of people you can contact. Also, keep an eye on NS-RBA and Nature NS, on Birding on the Web, for the latest news, views and sightings.
Hope this helps, and contact me again if you need further info.
Richard