Going by my personal experience, I downloaded the shortcuts app back when it was still "workflow" and the developers charged $3 for it. I played around with it for a day or so, then forgot about it. While Macstories was an ardent fan, I just couldn't find a use for it, and the programming-like manner in which I had to go about automating tasks was just too steep a learning curve to me at the time.
Then about two years later (yes, that long), something just clicked and I played around with it some and successfully made a few workflows. I haven't really created any new ones of late, but I am still using the ones I created (and they have since paid for themselves many times over).
I find that in order to find value in the app, you need to enter what I call an "automator's mindset". This app really only works when you find yourself having to perform the same task over and over again (else, the effort that you have to invest to make a complicated workflow work makes no sense if you are going to use it only once or twice), and even so, you have first be aware that you are in fact performing said task repetitively, and have a desire to streamline it.
Some simple workflows I have created are designed to launch me straight into sections which can be more cumbersome to access, such as the music and chill mix sections of Apple Music, and the app updates and subscriptions pages for the App Store app, since they just require you to paste the appropriate link in safari. I have also created a workflow to convert HEIF photos to JPG, and a few more work-specific workflows that apply to my work as a teacher.
So I guess the first thing you need to do (and which you probably won't be able to answer right away) is to identify what small tasks you perform on a regular basis. For instance, do you find yourself texting someone the same few messages (or could they be the same few texts?), or firing off a rather templated or similar email weekly? Then work on seeing how you can replicate the process in shortcuts.
The initial step is always the hardest, and it may not always pay off, but it can be a fun use of an afternoon here or there.
Here's a good repository to get you started.
Apple news, app reviews, and stories by Federico Viticci and friends.
www.macstories.net