You really have to make your own decision. If you have specific questions about features and ability difference between Note 9 and Note 10 please post them. Then everyone can provide answers and help you collect the data you need to make your decision.
Yes, Absolutley. I own the phone and I am extremely pleased. Now if you fo get it make sure you have the liquid security glass. Iy is awesome in graphics and photos. I hope you buy it so you can enjoy pictures taking and the awesome volume on it.
What everyones opinion? Should I upgrade to the Note10?
If your Note9 is in good shape, with good battery life and you are happy with it, I would keep it.
If your Note9 can be traded in to Samsung.com for a good amount of $ and it is better then how much it is worth, I would do it. I did it with my S10e and got Note10
Otherwise it is really a waste of $, because you probably already paid a good amount for your Note9 + would have to pay few hundreds of $ again...adding all up, would make a good "old car" purchase.
I would say yes, but then I'm one of those crazy guys that gets a new phone every 6 month. The fact you're asking about it means you already want to, so if you can comfortably afford it, go for it!