A goofygoober is a super goofy kinda guy, that also is an idiot and can be used as an insult.
Person A - "this dude just spilt some lemonade all over his trousers and it looks like he peed himself and he hasn't even realised"
Person B - "What a goofy goober"