So basically, 1024^2 it's not good enough for today days.
It depends on what you are wanted to create! For Example an Metal Barrell could use an 1024² Texture... Small Objects like Books / whatever could use an 512² Texture. also 256² Textures could be applied for very tiny objects like switches.
So it all Depends on the Size of an Object!
regards Sebastian