Is it possible to do these things with the newest Raspberry Pi? Can it be souped up?

1) Stick ubuntu or some open source linux on it and run wine?

2) Play quake WITHOUT 12 hours of compiling?

3) Play deus ex?

4) Play outcast?

5) Play turok 1&2

6) Play stalker shadow of chernobyl?

7) Use it for video editing?

8) Use it for word processing?

9) Hook an actual hard drive to it? 1TB size?

For the most part, x86 games aren't going to run on ARM processors, so that answer to most of the games is No.

Apparently, you can use WINE with qemu to run x86 applications on ARM, but I can't image it will be speedy. It's also not supported by WineHQ.

If you use a USB hard drive, there's no problem hooking it up. It has to boot to the SD card though.

I don't think any kind of pie would taste good in a soup. You'd get a bowl of this moist, chunky, warm blob floating in a puddle of crumbs.

I've been thinking an RPi 3 myself lately, I don't know what's the current state of Ubuntu it but at some point there was no 3D acceleration, only Raspbian did, I don't know now.

As for Quake you might find a pre-compiled ARM version of it (probably all 3 games).

Video editing might be possible, but slow encoding, and word processing that's definitely a yes :)

As for WIne - you can build the actual Wine itself but the games will not run since they're still technically written for x86.

1TB HDD - Sorry can't help you there xD

1) I haven't done so myself but I have seen videos & some tutorials online about running Wine on Raspbian for RPi.

2) Yes, there are 3 open source engines (tyrquake, darkplaces, lr-quake) that you can use.
I installed tyrquake & darkplaces on my RPi3 (RetroPie 4.2) & got Quake1 all expansion packs working.
( I should post a tutorial on that later...) Also it takes moments, I installed from binaries.

3) Possibly with Wine, there is no open source port of the Unreal1 engine.

4) Possibly via Wine, but I don't think there's an open source engine port.

5) "Yes & No". There is no port for Turok1&2 for RPi as far as I know, but there are N64 emulators.

6) I don't think there is a port for that.

7) Possibly in Raspbian, but you will be severely limited due to the low amount of RAM an RPi3 has.

8) I think there is a Rasbian port of Libre Office.

9) Probably, via USB 2.0, as a secondary HDD. (Edit: must have a micro SD card to boot from)

Relating to that, there's an interesting story around the video game Snatcher. The western release has an interesting translation of one of the dishes that's available in the game.

What, Neo Kobe Pizza isn't a normal dish?

1. Yes, but wine will be running via CPU emulation, which is slow.

2-6. If a source port of the game exists, probably (though you will likely want to find a pre-compiled version if you don't want to wait for it to compile and don't want to try to setup a cross compiler). If not, and you somehow manage to get it to work via WINE via CPU emulation, it will likely be too slow to be playable (unless it's an ancient game).

7. Will likely work for some video editing, but the weaker CPU and low-ish RAM will be an issue.

8. Yes, assuming you don't try using a word processor that is too heavy. (Abiword should work fine, for example.)

9. Yes, but you will be restricted to USB 2.0 speeds. Also, the Ethernet adapter is connected to the USB bus, so if you are accessing the network at the same time as the hard drive, things won't be as fast as you would like. (I don't know how it works for the built-in wireless found on the newest models.)

Edit: Elaborated on my answer to 2-6.

Is there anyway.to build or get an x86 raspberry pi like device?

Nothing I'm familiar with, but a quick search turns up this

For much more money, yes. Minnowboard is one or get a mini PC like Intel NUC or comparable.

Depends on what you mean by "Raspberry Pi like".

The Intel Compute Stick could very well work if you're primarily looking for a small size, and by Intel's own page, the cheapest costs $37. If you're looking for a development board on the other hand, costs rise rapidly.

The Gizmo 2 is around $200.
SuperMicro's E100-8Q is about $200.
The Minnowboard is $150 to $200, depending on model.
PC Engines APU1 and APU2 seems to cost between $140 and $200 depending on the model
The UP board starts at $100

You can overclock. The ARM processor in the Pi3 is prone to overheating if you don't cool properly. You can install the ARM version of Ubuntu or Raspbian. WINE's out of the question I'm afraid because it needs a x86/x86-64 processor. There are efforts to get WINE running with JIT transaction of x64>ARM code, but the Pi3 won't ever be able to do so in any meaningful fashion. Don't know what's in the ARM Ubuntu or Raspbian repos, but Retropie certainly has binary versions of Quake in the repos. Just need the .pak files. Didn't run very well for me, but I didn't put much effort into config. I hear that recent versions use OpenGL instead of software rendering, which may run better. No. No. Only through the N64 emulator, assuming that you can get the performance and compatibility you need. No.

If you're looking to run games, DOSBox does alright for games up to a cycle count of around 6000. I've played and completed Might & Magic 2 on my Pi3. No. CPU and GPU simply aren't up to the task. Yes. Raspbian and Ubuntu both have LibreOffice in the repos. Installing a printer can be a bit of a chore though as you have to configure CUPS manually. Yes, but you'll need one with its own power supply or a separately-powered USB hub.

https://en.wikipedia.org/wiki/Pie_floater