Regarding your questions:
1.) It depends on both your level of experience with computers, programming, etc. as well as the language(s) you intend to use. Note that each host decides which languages to support, so that factors into the decision. In addition, it depends on how advanced/complex you want the website to be; some simply create a static yet elegant page that displays basic company information while others have feedback forms, user accounts, shopping carts, etc.
2.) Templates are ideal for those who do not have the time and expertise to design a page, both graphically and programatically. They're great if you want to use them as-is, but but keep in mind that there's often a steeper learning curve should you want to customize them since their logical approach may be far different from your own.
Note that templates are often created, and customized, using Dreamweaver, Expression Web, etc, so you should focus on the quality of the design and developer rather than the tool used.
3.) There is a learning curve for the user interface (where the options are, what each one does, etc.), just as there is for any new program. The most challenging part is learning the development languages and implementing proper solutions.
4.) It can go either way, depending on your business, your customers' desire/need for the website, your knowledge of programming, your dedication to the site, and the intended depth of functionality.
Bottom line: Start with a solid template to reduce the initial workload, use the template creator's customization services if available, and keep it as simple as possible while still giving your customers what they need.
Hope this helps,
John
Maybe I'm nuts, but I'd like to take a shot at creating a website for my business. I don't have a lot of money to spend on having one created and added to. I know I need a domain name and a host, but that's about it. I have some questions:
1. What is a good book to get started? I've looked at a couple on Amazon, but none really grabbed me.
2. How good is a website created with templates on a place like Squarespace compare to one created by a company (I know you get what you pay for so not high dollar) compared to something created with Dreamweaver (the first recognizeale name I thought of)?
3. How hard to use are programs like Dreamweaver if I decide templates are too restrictive?
4. Is maintaining a non-commerce website, either on a place like Squarespace or created with Dreamweaver, a time consuming P.I.T.A.?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic