Yeah, I think you can know your origin with pretty much no issues, whereas forcibly awakening to it can create the likes of Lio Shirazumi from KnK who is irrefutably insane
(He possibly was prior to awakening though, so it may have just exacerbated the situation).
That said, several other characters with awakened origins are at least able to function fairly normally (notably Ryougi Shiki, Tomoe Enjou and Araya Souren), though all of them are at least a bit odd at times (being fair this statement does apply to lots of Magi as well...). Origins are explored much more in KnK than F/SN, so poking around with the materials from that might be helpful in ironing out any issues you have.