awesome video effects

[forare]

I have just seen someone's wedding dvd and the effects are awesome and very proffesional. I was wondering what software can produce these ? i have tried almost any digital video editing software and did not see such effects in any of them, can anyone suggest any program ?

thanks