Thanks to this site and others I am painting my living room and sun room Tobacco Road. I had it mixed at SW (thanks for all the info) on where and how to get it. But I need HELP!

Here's my question. What color should I paint my dining room, which is adjacent but not open floor plan?. The house was built in 1900, so it has archways and most rooms are separate. When we moved in and did renovations, I had so many choices to make that I rushed and picked colors. I had originally painted my living room a BM Peaceful Jade green(Serenity Collection) with darker green accent wall when we first moved in. I always wanted a red dining room, but my husband balked 7 years ago, so it's a very bland pale, green(Zenful,from same chart) that basically looks white. In order to give it some color I added curtains in a Color similar to BM Raspberry Truffle and my area rug is also in the same color with green and goldish beige colors. The area rug can go and so can the curtains. My kitchen is a nice warm butter color from Restoration Hardware. I have Fiesta ware, so there's alot of colors to accent it. I do have red patterned valances to help tie in the colors. I also have red patterned pillows on my expresso colored leather sofa, and small loveseat in sun room is a neutral beige. I liked the green, but was never quite happy and now a bit tired of it. I also used to be fearful of "color", but now want more color and not washed out colors. I don't want to screw things up this time, since I hate to paint and there's alot of molding. My husband will kill me also if I don't like the final outcome. I still would love red (with chairrail and molding below in white) but is it dated? Red just makes me happy and every time I see it in some dining room photos I still love it. Are there any other colors you can suggest that flow with TR? Thanks to all!!