nothing can act as a homehub except a HPod or aTV (or iPad).
And just to clarify, since the word "hub" is used a lot... A home hub is used to access your devices when you're outside your home network, and to handle any automations that happen when you're not home. a Home will work without them, but automations can be spotty.
if homebridge (or home assistant) stop working, only the devices from that instance of homebridge will go "no response". It might cause some slowdown, and some annoying notifications from Siri when you're giving commands, but when homebridge re-starts they should start working again. BUT... if homebridge starts, and for some reason your config is messed up causing some devices to go missing out of homebridge, It's very probable that those devices, and all their settings, will be removed from your home. But no matter what happens with homebrige, your native devices will be fine, as will devices from other bridges. It's also possible now to run each plugin as a child bridge, meaning any problems will be contained to to that one plugin, and the rest should continue to work fine.
Having just had a Node update issue borking Homebridge and one of my plugins, I can confirm my (native) Hue lights continued to work just fine.
you can already trigger automations in the shortcut app based on focus changes. and add HomeKit scenes or device to that automation.
there are also triggers for mail received with filters for sender and subject.
but with iOS 15, shortcuts has added a lot of notifications and confirmations for things that are automatically triggered, so YMMV
for pressure/vibration sensors, check out the eve app, It's just a second front end for HomeKit, it has some more advanced options for triggering events, plus you can add conditions to automations. These will all still run from your home hub like the ones created in the home app.
for remoting in, most things will have a web interface, you can either (less secure) open a port on your router to access them remotely, or (more secure) setup a VPN sever on your home network, and connect to that, then access the webpages through the VPN. For either of these, you'll probably want to use a dynamic DNS service, so you can point your browser or VPN client to alexqndrs-house.dnsservice.com, no-ip.com is a decent choice for this.
the 2GB of ram should be fine, homebridge doesn't use much resources, unless it's running cameras.