Yeah there are pros and cons of whatever you use. The idea is to choose something that better supports what you intend to do and the way you intend to do it. Aquasoil is simple to use, but may have some longevity issues. The stuff doesn't stop being good for plants, but it loses it's granular consistency over time. So if you want to reset things over and over it may not hold up. It also costs more, but the system is plug and play if you go full ADA.
Soil is more work, but I've seen nice aquascapes done in mineralized soil. It is going to be even less friendly to resets and rearranging things, but the cost may persuade you to work with it's limitations.
I liked flourite since it grew cryptocoryns very well, and it seemed to be very stable granular texture. It is quite dusty at first, so has to be washed well and then handled carefully to prevent more dust from rubbing off the stuff. Once in the water and settled down it does fine though.
I've even tried Turface, that ball field soil amendment. It has good plant growth responce, but the initial start is harder because it isn't preloaded with nutrients like aquasoil is. I found it took a little more attention to grow stuff in it than flourite, and it didn't hold plants down as well. usable, but takes more fiddling and attention to get things started in it.