In Burlington i use a Whistler TRX-1 and 2 and find it the best fit for me and it works well, Burlington has lots of DMR as well as some NXDN conventional stuff and is also covered by provincewide NXDN (OnQue) and a Phase 2 system (Metrolinx).
Any digital scanner should be able to handle the Halton Region system as long as it does P25 but i would try to get one that does DMR and Phase 2 also as Fleetnet 2.0 is in the future.
SDS100 is a good option if you want one that does most things out there currently, although Whistler is coming out with a LSM compatible scanner (similar to what SDS100 offers) soon so depending on the prices you would have options when that happens.
Also nice to have a handheld DMR to monitor Burlington Hydro during outages, that happen too often.