I don't have any direct experience with the 900. I had the "One" when it came out, which was the IR version of the 900, right? Which I then replaced with an Elite, and added an Ultimate for my theater in the meantime. I think the 900 is a different hub than the two I have, but I very well could be wrong. It has happened before.
Anywho, I had a Vera 3 until I replaced with a Homeseer system in late 2016. But I had fairly decent success with reneboer's Harmony Hub plugin for both setups.
I can't remember the nuts and bolts of it, but I believe it created devices/scenes in Vera for each device and activity. Maybe just devices? It's been a while, and I speak Homeseer now . . .
But I have had favorable experiences with the Harmony Hubs and blasters. They are hardwired, no wireless solution that I'm aware of. For both rooms, I have my equipment in a "stack" and have no problem with the Hub/blasters hitting everything. In fact, in my living room setup, above the fireplace TV, I have one blaster on the mantle pointed in the vicinity of the TV, and one blaster at the bottom of the stack. I don't have my photos off Photobucket yet, but I'll try to post a picture later explaining what I mean.
Furthermore, I wouldn't let the lack number buttons dissuade you from the Elite. I really don't ever need numerical keys, what with the graphical shortcuts on the Elite's screen, and my Tivo's on screen guide. And perhaps Alexa would help you with that? The Elite is a far better remote than the Ultimate, and I personally prefer to the One. Mostly for the RF of it, which you already are accustomed to.