Hoping someone can help and advise me with the question of which program to use?

Dear Adobe Community


I’m hoping you can help and advise me with the question of which program to use?
 I have tried looking up this question/dilemma on the internet but got completely bamboozled but all the different answer, opinion and possibilities.

At the moment I subscribe to Lightroom Classic and Photoshop. The program has to work on a new MAC computer and hopefully interact work with Lightroom Classic and Photoshop.

For my work as an artist (Painting and Sculpting). I have been collecting using ‘inspirational reference catalogs’ for my work.

Recently I have collected about 70,000+ photos of - light, colour, texture and mark making. With these photos I’m hoping to make a film of some description . What I’m thinking for a possible solution is the way an old fashioned animation cartoon is assembled the individual frames/cells/photos joined together to make a film. I need a program that’s relatively straightforward forward to learn and use but not basic in the creative possibilities, where I can arrange and rearrange the photos in sequence and play with the time-spacing ect and eventually adding sound.

I have not considered AI as a possible solution, as I know nothing about it and have terrible internet.. even though I appreciate there is so amazing things being done, and this, just the beginning of AI in art and film ect…..

I would appreciate any thoughts and feedback.

Thanks
John