"every click requires a special consideration (ie, run as Administrator)":
Disable UAC click here
Windows Vista Software Compatibility List click here
"2008: I have tried for 3 weeks, and very VERY few programs install and work properly (at least programs I need to run my business, editing).":
I have had Vista Ultimate for about Three Months, Best thing since Sliced Bread.
I also make Videos using Ulead Video Studio 11.5 Plus, No problems with Vista at all.
How to downgrade from Vista to XP click here