Well, I'm partial to "main street" kind of towns, and also historic homes, so Franklin has both of these. I'm trying to even remember if Murfeesboro had a "downtown" type street. I just remember it being a little more of a country feel. Like I said, I can't remember the "town" itself. Have you looked into Franklin? To me, Franklin is the ideal town. It's near enough to Nashville, it has the "Cool Springs" area, which is a shopping mecca, and it has the historic main street with quaint shops, and historic homes surrounding. But, this is all just *my* opinion...others may have different ones entirely on what constitutes a nice town to live in. Franklin will be more expensive than Murfeesboro (I know I'm butchering the spelling!), so it does have that disadvantage.
Oh, one thing that the Raleigh area has over Nashville, is that it's near the coast. That was the one thing we didn't like about TN... we weren't near water. We grew up on the east coast though, so being near water felt normal to us rather than being in the middle of...well, nothing.
Hope this helps!