Anal. Is it great or not at all?

I've heard it isn't all that great from some men. I know it's everywhere in porn. But truly in every day life, how many of you are participating in fucking your womans ass? Is better than a vagina? I feel like there's so much hype around it 🙈