The original post asked minumum radius required, but that answer varies greatly.
6 Axle GEVO’s & SD70ACe’s can run on 22" curves, but do they look good? That is up to you. Similar sized diesels can do these same curves. Me - I like to run trains, and I have a few 6 axle units that will be run on my 24" mainline curves. I do know that some 6 axles can operate on as tight as 18" curves, but not all. (And only if they are not coupled directly to larger-sized cars.)
Bachmann’s 2-8-4 can handle as tight as 18" as well, but is better on larger 22" (or even bigger) curves. (Who doesn’t like 765?)
But bigger is always better, with the caveat that you must be able to fit bigger for it to be better. Sometimes space is tight, so we build what we can, where we can.
So, what radius is a very hard question to answer, as there are too many variables to consider for a blanket answer, unless that answer is “It depends.”
(But I’ve seen some really big equipment run on really tight curves in a pinch. One show I attended had a “show-stopper” on a 22" radii curve layout with zero derailments - a Bachmann Schnabel car! Everyone simply stopped to watch that thing, and everyone I saw was impressed!)
Last question about point to point with 42", or dogbone with 32" - You answered it yourself when you called the 42" minimum radii mainline “boring”. Build the dogbone with 32" curves, and enjoy it.
Will my trains “look good” on my 24" radii curves? My definition of “look good” on a model railroad is that they run smoothly, and that the operator finds enjoyment in it. So they will look perfect to me. [:)]
Your answer may be different, but when it comes to model trains, the only important answer about your layout comes from you. It’s your layout, build it where you can fit it, at the size you can fit, how you will enjoy it. If others prefer s