Oh my. And oh my.
The first "Oh my" is your first video with the awful idle. The engine is obviously missing, what's a mystery is why the ECU isn't turning off the injectors for the cylinders that are miss firing. It's supposed to in order to avoid flooding. The strong fuel smell is a clue there.
Oh my #2 - that's about as bad-looking an engine compartment as I've ever seen. The air filter is no longer filtering air. The rips in it indicate it's had a rough life, and I bet the pleats are full of whatever the sandlike dust that's covering everything in the engine compartment is. You put 14,000 miles after purchasing it - and I'm guessing with no service besides oil services? At 120k miles a major service was due, and given the condition of the engine compartment, I can promise that was never done. There may also be a leak in a hose in your 4th picture in your gallery, where the hose is up against a sharp edge of what I assume is the AOS.
You need a new air filter. You should clean the engine compartment BEFORE installing the new air filter. Your MAF undoubtedly is dirty (CRC makes a specific electrical cleaner for the MAF - big box auto parts stores carry it). The AOS may have failed (it certainly wouldn't be a surprise given how the rest of the engine looks, it has obviously been ignored for a long long time..) You really should do the entire 120k mile service, but you can skip things like the serpentine belt until you have the engine running correctly again, the belt isn't causing this.
I question using Torque to read the codes. Does it have a separate Porsche module (I own it, but can't recall one), if not - Torque is only reading the OBD-II codes. In that case, there may be lots more codes stored away in the ECU that Torque simply can't read. There are also faults that the Torque probably can't reset. Since it's a 987, the tool I'd recommend is the Foxwell NT530 with Porsche module. It offers good coverage of the 987 series cars.
If it wasn't for the strong smell of fuel I'd be questioning the fuel pressure. The strong smell of fuel also brings up the possibility that an injector has failed and is leaking fuel into a cylinder.