I gotta say. Sunbeams, burning, and scorching look nice. But they're wayyy out of my budget. (One of my friends used to have a scorching Brotherhood of Arms [around 900 keys] but he sold it to get a better PC)
During the summer I'm probably gonna buy all my items back and get either a Frostbite, Death at Dusk, or Cloud 9 Crone's Dome. Since those are the 3 nicest effects imo that aren't god tiers
Other than that though some cool effects I like are the halloween weapon effects Halloween Flames and Pumpkin Bombs.