Unless I'm mistaken, what the original poster is asking for is a stock-by-stock analysis, which I'm not sure any of these tools provide.
For instance, If he owns $50,000 worth of QQQ, he wants to know how many shares of NVDA he "owns" within that ETF. Or in a VTI mutual fund, how much MSFT exposure does he have.
Unfortunately, I don't believe there's anything remotely like this, for several reasons. First, Index ETFs are sometimes proxies for stock ownership - they don't actually hold the individual equities, and instead use derivatives or phantom tracking stock to derive returns. Second, mutual funds only are required to disclose their holdings periodically, and their latest holdings list is almost certainly dated by the time you see it.
Cathie Wood (like her or not) actually set a pretty high bar by disclosing trades in her ARK funds on a daily basis, but I'm not sure her information is completely accurate between regulatorily required disclosure periods.
OP - your interest is laudable, but either you have to buy stocks individually (you listed AAPL and XOM) to truly know how much exposure you have, or the alternative is to categorize the holdings in somewhat arbitrary buckets (like IWM, QQQ, SPY or midcap, small cap, energy, technology, etc.).