I'd say that the RV-9 has about the same IFR capability as a similarly equipped Bonanza flown by a similary qualified pilot.
In other words, there will be days when you will stay on the ground, there will be flights on which you turn tail and go home, there will be flights on which you'll divert to an alternate, and there will be those rare flights that you wish you hadn't attempted.
However, on most days, you'll be able to complete the flight safely. You'll get good at reading the weather the day before and deciding if you should wake up early enough to trigger your backup plan: drive, telecommute, take the day off, or whatever your particular job dictates.
Some days you won't be able to fly home. So keep a beater car at the office airport and expect to drive home occasionally. Which, of course, means driving to work the next day.
The RVs have the speed, ceiling, climb rate and range to give you lots of ways to stay out of trouble, unlike (say) a C-172. I've flown in IFR a bit in the Northeast in Warriors, C-172s etc. Headwinds take a huge toll on 110 kt airplanes. Limited range sometimes means the inability to circle around the weather, or having to make a fuel stop at an airport with lousy weather or a difficult approach. Being able to fly at high altitude means you can stay out of the clouds more often, letting you steer around nasty-looking buildups and avoid ice. It's better of course to avoid ice and buildups by not flying on those days, but it doesn't always work out that way.