There are so many more textures and flavors than the average American grocery store offers. Additionally, what is typically sold as "cantaloupe" are usually muskmelons so there is confusion caused by marketing.
There are eight distinct groups (some refer to them as subspecies) of Cucumis melo (melons). Although they are useful in sorting melons for descriptive purposes, all groups will cross with each other.