I have never requested a water profile. I live in Philadelphia and I've been told by my LHBS that the water is decent for brewing except for the chlorine and chloramines, so I do currently add 1/2 campden tablet to my brew water but that is all.
If that's what the local advice is, then follow it for the time being. The beer will be fine and you have lots of other things to worry about that will have more direct effect on your beer. The fact that you're already brewing decent beer is another reason to be relaxed. I think you can sum it up as :
Water is of 3/10 importance to make good beer, but 8/10 importance to make great beer.
At this stage you just need to know that it's got no nasties in it, which you don't need a water report to know - if you can taste the chlorine, or it's hard enough that everything furs up, then it needs some adjustment, but if it just tastes like "water" then it's good enough to make good beer. On the other hand if you do run into problems, then it's one of the first things to look at.
If you want to do more than just follow the LHBS advice then one easy option is to look on your water company's website for a water report - I don't know how it works over there but in the UK you just enter your postcode to get the latest report for your local reservoir. It's not an ideal replacement for a test on your actual water supply, but for non-commercial brewers using the public supply, it's good enough. Things you are looking for are calcium (Ca), chloride (Cl), sulfate (SO4), total hardness or carbonates (CO3) or similar (they're frustratingly inconsistent in how they present this) and pH.
You need a certain amount of calcium for the mash enzymes to work, the ratio of chloride:sulfate affects the bitterness and mouthfeel (NEIPAs are high chloride, West Coast IPAs are high sulfate). You can reduce some forms of hardness by boiling the water the night before, hardness also means higher pH. Most water benefits from half a teaspoon of gypsum (calcium sulfate) if you're making bitter-led beers.
The pH in the report just gives an idea of what you're up against, the only pH that matters is what is actually going on in your mash. Somewhere around 5.3-5.4 means your starch conversion enzymes will all be fairly happy, it's like mashing at 150F you can tweak it either side to favour different enzymes. But pH is not quite as critical as people make out - unless the mash is drifting up >6 when you may get off-flavours, but you need pretty bad starting water for that to happen.
So the place to start is with some pH papers - they're pretty crude but they give you a reasonable idea of where your mash is at. You can use all sorts of things to change pH - normally you need to reduce it a little bit, my brewing water starts at pH 7.5 and my normal 100% pale malt mash is about 5.8. Dark malts are more acid, so you may not need any adjustment if you're making a porter etc. If you're brewing to the Reinheitsgebot you'll have to make adjustments using acid malt, but normal people just use things like lactic acid - again your LHBS will advise. I have used a small slug of wine vinegar in an emergency, although it's not ideal - heck, you could even use Pepsi! Probably only in a dark beer though - a Pepsi porter?