Cement board is more than sufficient. The other options are nice and a lot easier to work with, but are also a lot more expensive. I’ve been in some form of residential or commercial construction for nearly two decades and 95% of the tile jobs in bathrooms had cement board behind them. Make sure your tile guy tapes the seams with fiber mesh and floats the joints with thinset and you won’t have any issues.