Question Best Area to Stay in Prague?

We're planning a trip to Prague and considering staying near St. Nicholas Church on the Palace side of the river. Are there any specific areas or neighborhoods you'd recommend for first-time visitors? We're looking for a place that's central, has good access to public transport, and is close to major attractions. Also, any tips on what to expect in terms of noise, safety, and local dining options in that area would be super helpful. Thanks in advance for your insights!