Second (or third) on the wireless charging and file transfer for any phone or tab. And good Qi pads and receivers are cheap now. $35 buys you a pair.
The video leaves out one thing. Flipping the latch on the ribbon cable connector isn't "simple". If you've done it many times (as he obviously has) you can just about do it with your eyes closed. But I've seen many phones come in because something appears intermittent, and it's a broken latch on a connector, so the connector is loose. It's VERY easy to break the latch. So if you ARE going to repair your own phone or tablet (my standard advice, after years of repairing what someon else "repaired", is DON'T!) be VERY careful lifting the latches and connectors.
And if a device charges only if you hold the cable in a certain way, or it stops charging if you move the cable, that means a bad solder joint. That means that every time you move the cable and make or break a connection, you make a spark. It's hot. It damages the board that the connector is on. In phones where replacing the connector means replacing the board it doesn't really matter too much. But in phones where you can just resolder the existing connector, you can pay a good shop about what the board would cost to just touch up the solder connections, and the USB connector will be tight and safe again. (And you don't risk breaking anything.)