I believe the reason the tiles work well with the cabinetry is because the tile is lite in color and flat, its not rustic unlike most terracotta. The expensive cabinets work fine with the floors because of the smooth finish. The floor here is the focal point of this room. The Interior Designer or whoever did this room, did a very nice job, keeping it very simple.

I agree with you the pillars are unfortunate. The replacement tiles will stand out no matter how close they come to matching so you're better off making sure they are clearly different so the gray one is better. Putting busy mosaic tiles could look nice but will interrupt the flow between rooms which I'm guessing is your problem with the columns in the first place. You will need to create a dextrous solution to tying into the 2x4 wall on the left side but I think it can be done tastefully- maybe beveling it back once you get past he end of that wall.

I have just taken a couple more pictures (excuse the untidy house) from the stairs. As you can see it's an open plan area that isn't that big but very high ceilings also in wood (Macrocarpa) with dark wooden beams. The house is surrounded by bush so quite a dark house. I initially considered a darker wood similar to the beams but not sure if that will make the house appear smaller / darker...I'm really not sure what to do!?!?!? Thanks

Thanks :) Yeah decided to go with tile. So sand cement is ok over existing tiles if I prep them first? Only problem is, the new pad can only be about 30mm at it's thickest (leaving up to 15mm for tiles) otherwise it'll end up being higher than the hallway floor. So I either need to make the fall shallower or not bother with the waste and make it all level. If I made it level, could I use levelling compound at that thickness or would deck mud/sand cement be the best option? Also, should I be putting in mesh for strength? (I know I should (and will) ask the local hardware what they suggest, but it's great to have suggestions from the Houzz community also)