Insights into Improving Performance of Niobium Superconducting Transmon Qubit Devices through Advanced Microscopy