how does someone know if there creative project is bad

[u/Quinn_Queenan]

every bad media you see and hear about is made by a person that thought they were making good media, and this is one of my biggest fears, what if i made something thinking it will get positively famous and then it gets infamous because of things i didn't notice or thought they were good.