I recommend the novel,"The Prince Consort with Explosive Liver", to you. Although it's a novel and not a manga, the plot meets the requirements. The male protagonist, Wang Xian, was a third-rate cartoonist. After his sudden death, he transmigrated to the Northern Song Dynasty and possessed the legendary romantic son-in-law, Wang Shen. For the sake of his dream, he resolutely started his own comics career in the Northern Song Dynasty. I hope you like this fairy's recommendation. Muah ~😗