There is good enough, then overkill. You could add three four or five layers to your shower walls, but it's not necessary. If it's inexpensive, and makes you feel better about the job then do it, but it might not help.
Most of the baths I do are tile over mortar bed. The only membrane is tar paper. I've pulled those assembly's out that were over 60 years old with no visible rot or decay. I just pulled out a shower that was 10 years old, used four times a day, and it had no evidence of failure or leakage. It was Hardibacker nailed to framing, no waterproof membrane at all. While it's not something I'd do, it obviously worked.
Tight joint ceramic tile with non sanded grout is almost water proof, there should be very little moisture coming through the assembly. Most systems in use today rely on providing a path for that moisture to escape, and they work as long as you pay attention to the details. Beyond that you can spend as much time and effort as you want to achieve a totally water tight instillation, but understand that you're buying piece of mind, not a better job.
Edit: If waterproof integrity is your primary concern, a one or two piece fiberglass unit will never leak. But they look cheap and flimsy.