Philomena Cunk on Star Trek

"Who called it the Guardian of Forever?"

"Well we don't know, actually. Academy scientists assume that it's some sort of life form that coalesced around the myriad beliefs of sentients regarding the understanding of time and adopted language to best fit their understanding."

"So it gave itself that nickname?"

"In a sense, yes."

"Like when me mate Paul had that ketamine and declared himself the Unstoppable Love God until the police wrestled him to the ground?"

"I... suppose you could say so."

In Discovery they explicitly show it going full Q when testing Georgiou, so it's entirely possible it allowed people to do stupid stuff as a test or a lesson.