I live in the region. I think the comments posted so far are pretty accurate, to tell the truth. Roseville is at the base of where the foothills to the Sierras start, so flooding risk is limited to creek side areas for the most part. The American and Sacramento rivers (the ones associated with disaster potential) do not go thru Roseville.
Roseville is a tad sprawly, so if you are from SoCal, it will feel familiar. There is a big indoor mall there. You will not be want for anything - Roseville has everything you may need. The commute on I-80 to downtown is bad, but not long-lasting - we do not have 24-hr rush hour like on the 405. If you live and work in Roseville, commuting will be easy. People here complain about traffic - they have not lived in L.A.
About a 2 hour drive to SF, but Amtrak runs there as well. Napa is about 90 min in good traffic, but there are good wineries in the hills in El Dorado and Amador counties, about 45 min drive.
North Lake Tahoe is about a 90 minute drive from Roseville - you can be in the snow (in winter) in about 45 min. If you like to bicycle, or run, the American River Parkway runs about 30 miles from downtown to Folsom Lake - a paved bike trail the whole way - tons of people use it. Boating on Folsom Lake (until the water is drawn down - this week). There are a lot of outdoor activities in the area - you will see a lot of homes with campers, trailers with jet skis, boats, kayaks, dirt bikes and other toys. People leave their ski racks on all year long (optimists).
Summers are generally on the hot side - about 10 degrees warmer than the Bay Area (altho the last week has been awesomely cool!). Each summer there is usually a heat wave where we are in the 100s for a few days in a row. Winters are generally about 10 degrees cooler than the Bay Area, and there is risk of Tule fog after storms.
Sacramento is not on the tourist trail, but there are a number of good attractions to check out in town. Mid-town (east of the Capitol area) is known for a number of good restaurants. The area lacks world-class cultural exhibits you may get in L.A.
As stated, the airport is a cinch - about 30 min drive to and from Roseville. If kids are in the equation, I think Roseville has a good school district (but not sure). Good luck!