Some versions of the O-470 are regarded as "bullet-proof" on the same level as the O-320 and O-360. An excellent choice if you have an airframe large enough to justify the extra weight and power. But I believe most of the engine experts will say that a 540 Lyc will produce more power to weight than an equivalent 470 Continental?
The Cessna 180 and 182 series, arguably the greatest general purpose utility, pickup truck, medium bushplane, and family cruiser series of airplanes ever built, is based on the 470.
The Bearhawk is a good candidate for the 470, although many Bearhawks have gone with the Lycoming IO-540. A 470 powered Bearhawk would make a really neat and smooth running bush/utility ship.
I have a friend with a Cirrus VK-30 pusher, and this airplane uses the slightly larger (but same family) IO-520. Works great.
If you want to go FAST, you can install one of these engines on the larger 4 seat Lancair.
If you want to go fast and COOL, you might be able to get Ralph Wise in Mojave to draw you a set of plans for his current 2 seat tandem "sport plane"
If you want to do aerobatics, there are several biplanes that might be able to sue this engine, modified with fuel and lubrication suitable for acro. I'm not an acro airplane expert at all, but I am guessing that those experts might tell you that the O-470 is better suited to a large "touring biplane" like a Great Lakes. The reason is that the hardcore acro guys all seem to be using the Lycoming 540. Probably the P-W ratio thing again.
The real answer of course depends on what type of flying you want to do.