Like you said, in my opinion the best material for a wall is a seamless UVs with a seamless material that way not only you can change the material you can connect walls to each other with a little tweaking. I have full levels where walls connect to each other with almost no notice of where they start and where they finish and yeah leave the complex UVs for complex stuff.