Yes it's normal for some people to enjoy the smell of their own farts.
I hate the smell of any farts including my own farts but as a kid I remember getting caught by the teacher in Kindergarten trying to smell my own fart.
I thought I was gonna die and never be able to face that teacher again but not many years later I look back and laugh at the thought of getting caught by my teacher smelling my own farts.
I don't smell my own farts on purpose anymore though because it disgusts me but for some people they enjoy the smell of their own farts and that's okay as well.
Everyone has some weird thing they do.