For many games there are even community high-def texture packs that you can add to make them look even better.
[Edit: Sorry, was talking about Dolphin here, not Wii U!]
Wii U's max HDMI output is 1080p. Also I have not seen any information that it does upscaling at all, so if you have a source for that, I'd like to know it.
There are a handful of GameCube titles that were 16:9 native widescreen on the original console. The one that comes to mind for me is Serious Sam: The Next Encounter
If you want the clearest 480p, the original Wii will do. With component cables and a compatible TV, it should be just as clear as DreamCast VGA.
Snapdragon 845 is the entry level where you can play maybe 50 percent of games at full speed, and a few at full speed and higher than native resolution. If you want to run at double or triple native gamecube resolution I'd recommend at least an 865.
Also keep in mind some phones like Pixels disable video out. Get an HDMI+PD adapter to keep your phone charged while outputting to a TV. If your phone's USB port is limited to USB 2.0 speeds you'll have to get a DisplayLink adapter.
My point is in theory, given enough time and effort, the Pi 4 should have more than enough power to emulate a 20-year old device. I'd argue that it's certainly not "way way too weak" as the reply above suggested.
The CPU isn't much of an issue.
Emulating a platform at such a low level in real-time is very heavy resource-wise, by design.
> VideoCore VI @ 500MHz: 500 [MHz] x 2 [slice] x 4 [qpu/slice] x 4 [processor] x 2 [op/clock] = 32 Gflop/s
which is the RPi4 config.
compared to a Snapdragon 800: 147.9Gflops FP32, and that's still a very old part.
And about the Wii itself:
> With the Wii, Nintendo opted to go with an innovative control scheme, rather than to focus on processing power. It offered 12 gigaflops, which represents a 1.27x improvement over its GameCube predecessor
The margins are way too slim when counting emulation overhead.
As a bunch of RPis are headless anyway...
I figured with Rpi improvements (kernel/settings) and dolphin improvements, it was time to ask if it's going better now. Everyone seems negative (without data) here though.