The famed creature from Egyptian mythology portrayed as a lion-headed woman is the goddess Sekhmet. She is known as the goddess of war and healing, often depicted with a lioness head. Sekhmet was revered for her power and ferocity, playing a significant role in ancient Egyptian religious beliefs. Her dual nature reflects the complex relationship between destruction and creation, emphasizing the importance of balance in the cosmos.