On GSM, North America uses 850 and 1800 Mhz frequencies. Most of rest of world uses 900 and 1800. A quadband phone will work around the world. Dual and Triband phones are not as versatile.
With an unlocked GSM phone, you could go to Europe and buy a Pay as You Go SIM from Vodafone, Orange etc. (wth local number) and have cheap local phone service on you unlocked GSM phone. The disadvantage is you can't use your own phone number. If you had a locked Rogers phone, it would work but you would be paying high roaming charges. The advantage is you would be using your own phone number.
People buy unlocked phones for 1) flexibility of using different phones (many not offered by Rogers or Fido) 2) ability to have a local phone number in a foreign country while on vacation, traveling etc. 3) not having to sign up for a 3 year contract (typical of Rogers or Fido to get a free or cheap phone)
You can buy unlocked GSM phones at most Asian Malls (Pacific Mall etc.), Howardforums.com, sntraders.com, Tiger Direct stores or on line, Factory Direct stores or on line, Kijiji, craigslist etc. Pricing will range from $30-$50 for older phones to $800+ for state of the art Nokias etc.
If you never use your phone outside North America, or you intend to stay with Rogers or FIDO (same company), the only advantage to getting an unlocked phone is really the choice of phones available to you. Most locked GSM phones can be unlocked.
A SIM card that used in a regular phone, will work in a Blackberry. However none of the Blackberry features (BB Messenger, email) will work without a Blackberry data plan or specific email plan. A SIM from a Rogers iPhone (even if you have a iPhone data plan) will not let you use the BB features, without calling Rogers and getting them to permit the BB features to be enabled (no additional fee, but most Rogers agents do not know this can be done).