Somfy is not the cheapest way to automatic your curtains. Maybe it is the most expensive one.
I am looking now for a year or more a way to make my curtains smart. If I get a green light from my wife, I will go for the aqara b1 curtains motor.
This one can talk to homey whitout any bridge, and is a fraction off the price of a somfy.
If i look in the app store by homey, there is only a app witch let you talk with a bridge from somfy, so I think that if you go for somfy you have to buy a tahoma box. This makes it even more expensive.
My advice is, search in this forum for electric curtains or something like that, and you will find your answer on what type of motor you will need for homey.