CSGO has a lot of maps owing to the fact that they have an engine for making new maps and is open for the community.
They change active map pools often (maps on which ranked games can be played). You can also select which maps you want to play, if you are a de_dust2 stan then just play de_dust2 all day.
On the other hand, valorant has 6 maps (7 with the new update) and every map is active since its release.
Which model do you think is better? Do you think valorant will adopt the CSGO model once it has let's say 10+ maps?
IMO both have their pros and cons.
It's really annoying that valorant throws Breeze at you 3 times in a row and I just need a break from the particular map. It's also a hindrance while learning line-up dependent agents like Sova and viper. I once learnt lineups for Sova on bind and queued for unrated to test them out. Did not get a single game on Bind for literal 3 days or about 9 consecutive games.
At the same time, I think being forced to play more maps makes you a better and more well-rounded player. I never learnt maps like Train and Cache in CSGO properly because being the noob I was, I only learnt the typical maps (dust2, mirage and inferno) and only played them since I had the control. This continued for a very long time.
Playing new maps really encourages you to try new team comps and strategies with teammates. Also you have to use different agents as not all agents are viable on each map.