read some stickies on this thread and on the Curve discussions; you can go to BlackBerryFAQ.com and/or Stinsondog's tips site (it's right off JSanders signature); i would recommend JiveTalk for your first app!
not sure if Rogers would love you still
if you get it unlocked, you can use it with just about any GSM carrier