Prices for smaller Sydney homes have exploded over the past five years as cost of living pressures and mounting housing affordability barriers push families out of larger homes.