What software should I use to visualize a major renovation?
Sketchup might seem a little intimidating at first, but it is very easy to learn and use. There are a lot of great tutorial videos online. Also there are tons of free models available for furniture, fixtures etc.

I have tried a few specialized 3D home modeling programs. They all have a learning curve much steeper then sketchup and at the same time often produce inferior results.