'I've been waiting' how long exactly? Spells take time to build. Usually you should see something within a moon cycle. This isn't always the case. I cast a spell that took two weeks to cast and I saw result within a week, other times I've cast and it took 6 weeks.
About ranking, it's not exact. Someone could rate their own spell, use other accounts to rank the same spell, or have friends rank it high. Sometimes one person ranks a spell and no one else will rank it for months or years. Use common sence when it comes to spells.