I grew up with a wood stove as basically the only heat. I never thought of it as fun, but it was warm in the stove room, and that's where we spent our time. My husband grew up with a big fireplace, and he had sentimental memories of it. When we bought our house, we were glad for a masonry fireplace in the walkout basement. I think it took perhaps just one winter of our living here to realize that the basement was too cold to be comfortable in winter without a space heater. We did do pretty radical insulating and airsealing, but we decided that the fireplace was a contributor to the cold. We installed a wood insert and have both loved it.
My husband took a little while to adjust from fireplace burning mentality to stove burning. He wanted to open the door, poke at the logs, add a split here and there ... Now he's really come to appreciate the heat cycle of wood burning and would never go back to a fireplace. He also just appreciates the really solid heat. We've had a big cold snap here, and he didn't have time to stoke the fire this morning, but our basement was still warmer than our main floor. Upon waking, the kids immediately go down there to play (legos this morning) and to enjoy the stove. They love the fire. (In an hour, I had the big basement room up to 80 because everybody wanted to warm up.)
Growing up, I never thought wood stoves were fun. They just were. With our insert, I think the stove is fun. I like tending it during the day. (I also love to process wood, so that helps.). My husband and enjoy our down time at the end of the day by loading a big (or as big as it gets in our medium-sized insert) load before bed. It's our time to talk together about our days, about our kids, make plans, etc. We enjoy the heat and find the secondary burn on our tube stove quite mesmerizing. A wood stove is different from a fireplace, but yes, with the modern glass front, a wood stove can be fun. (I know our insert has an optional screen for the front to make it operate like a fireplace. My husband was drawn to that when we bought the stove, but we didn't buy it and thought we could get it later if we wanted it. With the glass front (and ours is a pretty small glass front comparatively), we've never felt the need.)
We picked our fireplace insert a bit more on practicality than on aesthetics (though neither of us wanted something that we didn't like aesthetically), but there are some stunning stoves on the market. If you do start thinking about stoves, the good folks here on this forum will give you lots of options and information. If you post floor plans or pictures and dimensions and things, they'll even start designing for you.
Oh my goodness, this is so helpful...thank you for taking the time to type it all (and I'll happily take any other experience anecdotes you have!). Your husband's transition is exactly the issue I'm wondering about, my hubby likes to poke and arrange and add wood and fuss with fires...I think he could really learn to appreciate the technicality of a stove burn but it is a tricky leap to take in case he doesn't like it. If your basement was heated with central air would your husband still prefer the stove/insert? I'm trying to figure how much the heating plays into why people love stoves, or if it's also the "art of the burn" in them .