Any size is good for a FC. The perks and rooms, garden and workshop access are all there when you have that FC house. Upgrading is something the FC can try over time and hopefully get lucky with a bigger house but no house is the worst situation for any FC because they don't have access to any of those things.