lugShare is indeed the resource that you want to use. It should show you the power levels available at the listed chargers.
Outside of Tesla, Superchargers are called DC Fast Chargers. DC Fast Chargers are different in that they charge the batteries directly without using the car's onboard chargers. In the case of DC Fast Chargers, the chargers are sizable in nature, hence the big cabinets that you see at Superchargers. A DC Fast Charger can provide a lot of current to charge a car. But they are limited by the technologies and the standards that are in use. Just like Tesla has Urban Superchargers, V2 and V3 Superchargers, CHAdeMO and CCS have different capabilities.
But to the basics of your question, a CHAdeMO can charge a 40kWh battery to 80% in about 40 minutes. It beats the heck out of L2 (aka J-177s and destination chargers - all AC, using the car's onboard converters) in time.
Do you need a CHAdeMO? St John looks to only be 170 miles from Bangor ME. You should be able to do and then charge on J-1772 or 120V at your destination.
But if you look at the PlugShare picture of CHAdeMO (below) vs the Tesla chargers (below that), it definitely appears that you have significantly more options with CHAdeMO. Is it worth the month? Since it doesn't appear that you HAVE TO, then I'd so no.
But it works well as an excuse if you WANT TO.
Nominally, at a destination, like at home, it is more advantageous to use J-1772 or 120V plugs to charge if they are in close proximity to your destination. St John has a number of slower connection available. If staying in a hotel, it may be advantageous to pick one that you can charge at. I've seen and charged J-1772, Tesla Destination, and 120V 15A plugs at hotels (See bottom for St John). A few days on 120V charges the battery just as full as a Supercharger.