Definitely worth a visit, although the extensive construction currently in progress makes it a bit less peaceful and picturesque. There is a shuttle that takes you from the street entrance on Queen Mary Rd up to the building entrance.
The history of Brother André and the Oratory is interesting, and the building is beautiful inside and out. The basilica may not exhibit the highly ornate, classical style of older cathedrals, but it has a modern beauty all its own.
Nice views of the city from the deck outside the basilica -- it might not be apparent from some photos, but you're pretty high up.