I’ve lived in a handful of different provinces and have family in basically every region of Canada and I have never heard of goof being used that way. Where did you hear that?
Calling someone a goof is just another way to say they’re being silly/ ridiculous, which I’m pretty sure is the same way it’s used everywhere else.