So I went the nuclear option deleted everything and recovered the wallet from paper back up. So looks like spendable balance is shown correctly now and blocks are synced. unconfirmed is cleared. Its been interesting learning curve on how transactions are made and go in the mem pool if anything.
Thanks for all the help.
Good to know that you got it sorted out, it is a learning process that everyone must undergo which may look tedious process but at the end it's just simple as that.
In the future, if you have a similar problem,s just copy the btc address where you feel the balance is onto any of the blockchain explorers listed below to find out the actual confirmed balance left in there.
https://mempool.space/https://www.blockchain.com/explorerhttps://blockstream.info/https://btcscan.org/https://blockchair.com/bitcoin