Good video showing current capabilities of the HarmonyOS PC. It definitely seems much better developed than previous Chinese OS like UOS or Kylin
You can only download apps from official store at the moment. There are things like WPS, and chinese alternatives of video editing and photoshop, which seem to work well. Browser is chrome 114 and webkit 537
Aesthetics wise, it looks incredible. It's really like a best of both worlds from Mac and Windows. Looks easy to pick up and nice file system. Much nicer animations and sophistication than Windows (in fact looks even better than Mac to me).
Overall I think definitely a viable choice for mainly word/excel type business users who have lots of money and want to support Huawei