Late to the game, need some advice (motion design)

Hello all, I am trying to return to the world of generative AI. A couple of years back, I was using SD and loras from CivitAI, but looking now, everything seems to be so advanced, I am not sure where to start. I am a product designer (aka UI/UX) and want to create abstract motion designs for various apps. This one here is a great example of what I have in my mind, My goal is to create fluid and elegant motion design pieces that I can use on screens, such as onboarding or various tertiary app screens for promotional functionalities.