Dropbox had to explicitly deny iPadOS app from installation on AVP as iPadOS apps are compatible and enabled by default.
More than a year later and Dropbox still continues to keep the app blocked.
At this point I will have to look at migrating to a different vendor for my cloud storage. I have yet to come up with any reasonable reason why Dropbox would make the decision to block their iPad app from installation on Apple Vision Pro.