feat: Add --cwd CLI option

[WillDaSilva]

Closes #6943

[netlify]

✅ Deploy Preview for meltano canceled.

Name	Link
🔨 Latest commit	b3c21f1
🔍 Latest deploy log	https://app.netlify.com/sites/meltano/deploys/63694d6f30261c0008551e54

[codecov]

Codecov Report

Merging #6964 (b3c21f1) into main (147d3ba) will increase coverage by 0.03%.
The diff coverage is 93.54%.

@@            Coverage Diff             @@
##             main    #6964      +/-   ##
==========================================
+ Coverage   88.73%   88.76%   +0.03%     
==========================================
  Files         284      284              
  Lines       20542    20573      +31     
  Branches     2027     2028       +1     
==========================================
+ Hits        18228    18262      +34     
+ Misses       1979     1976       -3     
  Partials      335      335              

Impacted Files	Coverage Δ
src/meltano/cli/cli.py	85.54% <75.00%> (-1.13%)	⬇️
tests/meltano/cli/test_cli.py	100.00% <100.00%> (ø)
src/meltano/cli/utils.py	83.80% <0.00%> (+1.05%)	⬆️
src/meltano/cli/dragon.py	100.00% <0.00%> (+20.00%)	⬆️

📣 We’re building smart automated test selection to slash your CI/CD build times. Learn more

[edgarrmondragon]

I re-ran the flaky tests and they passed.