One big sprite vs multiple smaller sprites

I am wondering which would be better overall: Importing one big sprite into Unity (f.ex. a house) or importing multiple smaller sprites into unity (f.ex. wall, door, roof) and combining them into a bigger visual in Unity?

I know it is dependent on your use case, but I am wondering which one to aim for if there's a choice. Smaller sprites would take less space, but is there a performance hit if I f.ex. have 100 houses which each consist of 10 Game Objects with Sprite Renderer vs 100 houses with just one Game object each?

 

yes it will destroy your performance to have high amount of spriterenderers

the big sprite is better in theory, but many times you need to separate the house because you need to open the door, open the window etc

in those cases you use many small sprites, however you dont load the houses that are outside of the camera view, that way you can interact with all parts of many houses without performance hit, but it needs a lot more effort to code