What is the ruling on creating media content that may lead to fame, and does this contradict the hadith: "Indeed, Allah loves the pious, rich, unseen servant"?

There is no harm in creating content that is permissible in Islamic law and beneficial to people. The creator will be rewarded for their good intention. The fact that the content might lead to fame does not prevent one from continuing with it, for what is blameworthy is the eagerness for fame, not its incidental attainment.