It's really fun but not for everyone. People who got into CS are probably gonna love it, maybe those who come from Siege, too. I think Overwatch players will find it too slow and end up going back to OW.
The ranked issues come from there not being enough people yet. Ranked had only been out for a few hours, so there aren't enough people at the high ranks for fast queues yet. Plus, a lot of the pro and ex-pro CS players were 5-stacking their queues. Valorant tries to find lobbies where the grouping is equal on both sides, and two really high-level 5-stacks are hard to come by.