Robert Burns painted The Birth of Venus on his bathroom wall, Sue Kreitzman filled her house with so much art she had to knock through to her neighbour’s … meet the artists who have turned their homes into masterpieces