I've personally found marijuana usage to give me deeper, sometimes even profound insights into the relationships and various situations of my life. You have to be careful in distinguishing a profound thought from a paranoid one though (which probably isn't real, because the paranoia weed can induce is usually over things that you have no real reason to worry about).
With that said, even the paranoia can keep you sharp and out of situations/relationships that you otherwise shouldn't have been in. Just be careful not to allow "irrational paranoia" to creep in and impair your judgment and potentially your relationships with the people close to you.
Also, take a break once in a while to consult with your sober mind, and see how your normal-thinking self feels about the high thoughts you've been having. The balance between the two is what leads to great insight, in my opinion.