Congrats. In my opinion, you won't go wrong with UCC. Yes, I'm from BC (one of 17 Canadians in my class). Feel free to PM me with specific questions.
As for accomm, it really depends on your style. There's good, new, clean housing in student residences near campus but also many good options in Cork city and environs if you're into the more self-styled thing. Many have found great shared houses near campus. All in all, better and cheaper options than Dublin, I think (though not cheap by Canadian standards).