Correct, seepage will occur through the grout lines.
The painted membrane work well and are used (almost) everywhere.
This Australian Standard has some good examples of where & when to waterproof - see the tables in the document. Regardless of what is specified, you might like to pay a...