Question: Do they actually help with security?

Answer: Yes, there is method in the madness, and UAC prompts do help protect you. By forcing you to confirm that you wish to take various actions, UACs prevent spyware and other malware from making changes to your system without your knowledge.

Source: PC World