As much as I like the idea behind Pine64, make sure you understand what you're doing - their devices usually need some time before they're useful, they might underperform, etc.
On the other hand, they're usually priced well for what they offer, and I think the ARM model of new PineTab might look better than their usual new offerings. Make sure to find out, how polished it is before you buy.

It's the moderation staff's responsibility. Sorry for nitpicking, I understand in this case it's likely the same people.

I just get triggered when I hear that an open source software developer should have any responsibilities at all (maybe apart from some extreme examples), and I wouldn't like this idea to stick in anyone's head.

From what I understand, the RISC-V ecosystem is not polished enough yet, so the state of PineTab-V roughly represents the state of the entire platform for desktop Linux.

My personal workaround is a smartphone book case with a spot for the debit card.

The entire idea of Ubuntu Touch device support, was to be based on Halium. It's a bit different than regular mobile Linux (outside of Droidian, of course), where mainline is a requirement.

Looks like they have valid reasons for doing this - also, remember: they still allow selfhosting. It's less about what they want to do, and more about 'people are shit, as usual, and this is why we can't have nice things'.

• KeepassXC should just work, if the browser's key was added to your KDBX database successfully. Other than that, I am surprised.
• Yup, the motherboard clock thingy is a consequence of Windows storing local time, vs Linux storing UTC. It's a minor thing to fix in any of these systems, though.
• Shortcuts thingy - never had a problem, although I did have a problem with KDE's keyboard shortcuts to run a program, which may be related workflow and maybe both were/are broken.
• KDE Connect is surprising, as at least for me it worked flawlessly
• The reboot thingy must be related to Linux Mint. I saw similar thing in EndeavourOS. One nice thing that some distributions implemented, is the ability to apply updates when you poweroff - from my point of view it's a less annoying solution than what you describe.
• I can't comment on the 'cherry on top' one without more details.
  I had a somewhat similar issue on my work laptop a short while ago, when I installed a program, which included a bugged XML settings file, then ran system update. When the updater tried to rebuild some caches (related to ie. icons, MIME etc.), some programs which use these caches simply stopped working. Reinstalling all packages with apt was the only thing that helped, to this day I do not even know all of the parts of my system that were broken.
  But this was one of these issues that happen once per 5 years, and leave you scratching your head and asking "what the hell is going on here?". The difference from Windows is that in Linux, you can have a high understanding of system's internal modular components (at the cost of time needed to learn it), and regular system issues can be identified after a few minutes of Googling.

I'm as skeptical as you are, but at least they automatically preinstall a few useful gaming apps by default, ie. LatencyFlex.

Maybe it's obvious, but how about Kodi?
It has support for CEC (for utilizing your TV's remote through HDMI), of course there are other input options as well.
There's plenty of plugins to support online video services. Needs some work to configure them, and sometimes it requires maintenance when a plugin stops working, but I was in general happy with the way it worked while I used it for a few years.

I imagine Meta will simply want to ensure that all content will be added on their servers. This allows to enshittify it for everyone (Threads users and those who federated alike). Federated instances will see the amount of ads included with Threads stuff, and will have to defederate. Then Facebook says 'hey, we made it possible to join us, but nobody wants'.

I'm guessing it's not a big deal to replace it with a third party text messaging open source app; I'm not sure about the Dialer, though.

It would be an interesting solution, to port a few mobile Linux apps to Android (some of them are already there) - I'm a bit worried about potential maintenance burden for platform support; but it could benefit KDE/GNOME apps by getting feedback from a bigger bunch of users.

From what I see, it is about their recent decision to defederate from two other big Lemmy instances (sh.itjust.works and lemmy.world), because these instances (where the registration is open, contrary to beehaw) bring a lot of trolls and moderation burden for Beehaw admins. They had a chat with sh.itjust.works admin staff and both are in agreement that until there are better mod tools, there's not much more that can be done for now.