off the shelf rods/pistons for 470 B stroker for best rod ratio

I have a 400 block and want to make a 440 crank stroker,and I'm leaning towards the 470 with the offset ground rod journals vs a 451.

Because this is a street combo and I want it to last as long as possible before rebuilding, I've been advised to try and achieve a rod ratio of 1.8:1 or close to, and to use as tall of piston as possible.

What off the shelf rod and piston choices do I have?

If you want to build a "budget" 470 then you need to start the process by figuring out which heads you are going to use and what compression ratio you want. Once you know those two things you can then search for a combination of off the shelf parts that will give you the result that you want. The rod ratio is irrelevant on a budget engine. If you want to design around a specific rod ratio then you'll probably need custom pistons since the odds are very low that you'll be able to find a long rod piston that provides the exact compression ratio that you want.

Getting the compression ratio correct is much more important than the rod ratio. Using the correct rings and bearing clearance is way more important than rod ratio. In fact, almost everything is more important than rod ratio for a street engine. The only people who care about rod ratio are a few F1 engine designers and few guys on the internet who argue about theory but don't actually build engines.