Too bad you don't have a selection in your area. We always have a variety from which to choose: Spanish, yellow, cooking, white, red, Vidalia...
I always use Spanish onions for Spanish rice. They're large and have a stronger flavor, though they mellow somewhat as they cook. For almost everything else (except for cold salads when DH likes red onion), I use cooking onions. They're mild, but still tasty.
I don't know the flavor profile your recipe, but if you don't want a strong flavor, cooking onions won't overwhelm your dish. Yellow onions are good, too, but they tend to get sweeter as they cook. They're yellow in color, like Spanish and cooking onions, but they're different varieties--that's why they're marked differently in supermarkets.
This is a Spanish onion (not a red onion--they're two different varieties, too):

What worries you masters you.