Limited options on the Homey bridge

Nope as many Pro options are developed by the community.

It isn’t a limitation of the Homey Bridge as that one doesn’t do anything beside playing the antenna in your Home. Homey lives in the cloud and Homey Pro lives in the CPU of your Homey Pro (sphere or Pro puck).
So the limitations is in the Homey (cloud) with or without Homey Bridge, that doesn’t matter.

Beside it is mentioned on Athom’s comparison chart it is also visible while selecting Homey in the Homey app store to verify available apps.

I think everything you wanted to know is here already.

And all limitations of both platforms that I know where here mentioned