I dont think I would use SMO for general "day to day" tasks.
However, if you are looking to automate operational tasks or integrate from a line of business application then this is a great tool to have in your bag.
I work for 1st Consulting, a small ISV based in the UK. We build web and desktop applications using the MSFT stack. Find us at www.1stconsulting.biz