My experience with getting a SIM in the US is that in the stores they try to sell you a subscription and don't really understand you're a tourist. One thing the Americans are really good at is squeezing the last buck out of your pocket, so even the prepaid offers are kind of expensive and have some automatic renewal options active. On the positive side, when buying a local SIM is that it comes with a number and usually much more GB than the eSIM providers give.

Luckily my home subscription includes free roaming in the US these days. But if I would want to get a plan for the US I would use Airalo or similar. However not the Asian ones (i.e. 3HK) as with them data moves around the globe and the latency is noticeable.