Gotcha. Yeah, I've seen another video I think of the same Architect, very interesting. I think you're on the right track w/ what you're doing and looking at.
Here's the video I referred to above. http://www.youtube.com/watch?v=SPh7pj3onqk It's not the best example but it conveys the point pretty well w/o having to know to many fancy SU tricks.
If you're primarily looking at this as a training tool for staff on hand then I actually quite like the method that was used in the video you mentioned. She sort of walked you through the kitchen area and towards the living room. You could imagine her doing this w/ a client and explaining various features as she walked them through as a real estate agent might walk buyers through a house. So maybe something like that could work for you, or if it isn't all in-house perhaps doing an animation of the same thing while recording a voice-over and then joining the two together. I guess there's all sorts of ways to do what you're wanting is the point.
But I think the basic answer to your question seems to be, yes. I think SU is probably the tool you're looking for. It'll get you quick results w/o much of a learning curve and you shouldn't hit a dead end where you get a model finally done and then find out you can't use it. Once you've got the model you can show it directly, animate it, put in on Google Earth, put it into the 3D warehouse, make 2d images of it to print out, etc. Any other 3d program is either going to be too limited (SL or buying some $20 architecture visualization software from Best Buy) or too time consuming (learning Rhrino, Viz, or many of the other 3D modelers takes quite a long time).
To get started, I recommend what I did. I just sat down and watched some of the SU training videos (you can find them on youtube or under the help menu in SU I think) for a couple hours. You could just sit down and start into SU and teach yourself but I think eventually you'll watch some videos and kick yourself for doing things the hard way or finding things you didn't think you could do which are actually quite simple.
I also highly recommend the videos at http://www.go-2-school.com/podcasts which I just found awhile back. There very helpful and actually quite entertaining in their own right.
Good luck, feel free to keep asking questions as they come up.
-Brodie