What kind of red wine to use in cooking?

I routinely cook with white wine, but rarely use red wine in cooking (except in making beef burgundy). If a recipe for a beef stew or beef roast calls for the addition of red wine, what kind of wine do you use? A merlot? A cabernet? Or is there something else? Will any inexpensive domestic red wine work?