This will depend on the nature of the path, gradual paths such as Tantric Hatha Yoga, the eight-limbed Raja Yoga of Patanjali, the Eight Jhana of the buddha Shakyamuni, Vajrayana Buddhismt, Mahayana Buddhism, Hermetic Alchemy, some upayas from Kashmir Saivism, Tantra, you name it... all of these are a kind of alchemical transmutation in which you purify your consciousness and realise Nirvana-Moksha-Kaivalya... You will transform yourself in a more purified state, you'll remove your aversions and desires and your personality will be refined, more virtuous, more peaceful etc.
In the direct paths of jnana & self inquiry, zen buddhism, Mahamudra and Dzogchen will try to pierce through the illusion and realise the true nature of the mind. This path is more sudden-like type of realisation like Satori, in which you reach moksha without really being purified (so few are the peope who are ripe for this path), in other words, you can have a jnani or an indian saddhus who is a jerk but enlightened, because enlightenment is not about being a saint, but realising the self is an illusion, their personalities is the play of the three gunas (tamas-rajas-sattva).
In both paths you'll disidentify from your personality, you'll see through the illusion, you'll see how your personality is just a bundle of thoughts that you identify with, you can still keep-use your mind-personality, you still have your memories, your expriences, your knowledge, but now you are not attached to them, you are not alanford but you still can play the character alanford.
The life of an enlighetened being is full of joy and suffering too, he just do not identify with them, for him, suffering there is, no sufferer, sounds there are, no hearer... there is awareness of the experience fully in the her and now, the enlightened being experiences the world fully as it is, in the most erotic level you can imagine. We are living in a psychological world, we never exeprience but our thoughts and feelings/sensations, the enlightened being lives on a soul-eros level, have better sex, enjoys better food, can simply enjoy looking at the magnificence of a tree or a moutain or a river and experiencing it on its own ground, in emptiness. The enlightened being does not avoid suffering and joy, but he fully welcomes it in total surrender, while we resist and fight (psychologically). Enlightenment is the dropping of resistsnce, is the end of suffering, is the end of desire, the end of seeking and the seeker, its to finally accept things as they are without striving to change and exert your control, remember we are talking in the psychological world.
You can still pursue the tantric paths/hermetic-alchemical/magical paths, you can pursue Aghora, Saturnine alchemy, Qlippoth, Tantric Hatha Yoga, they will lead you there if you know how to practice, It is all about removing desires and aversions, chose the path-system that seems most natural to you.