Logitech stopped selling new harmony remotes, but all the infra to configure them is still online and managed by them, and as soon as you have configured the hub, it does work totally standalone. I'll worry about another brand when I buy new hardware and the harmony configuration infra is no longer online (I'm pretty sure there will come an opensource alternative)
About the update: the secret here is 'dont connect your tv to the internet, there is 0 use for that'