Imagination is the only limit. Photocompositing allows to create a lot of things but is very difficult in order to get something realistic and coherent. Light, shadows, colors, angle of view, all must be carefully controlled to get a satisfying result.
I used to work with Affinity Photo which is a Photoshop-like. It allows to compose images easily with a lot of settings available.
All my composites are AI free. This is the result of many hours of work and reflexion.