Should I use the server side for tweening instead of the client side for game logic?

TweenService V2 is your best bet for the actual appearance.

Server logic is a tough one such as bullets through a doorway.
TweenService V2 will update the position on the server once the tween is completed to ensure that new clients see this and server logic works. It’s not ideal to have server logic rely on position when something moves. Your best bet may be chopping the movement into smaller parts so the server still doesn’t run a tween, but does more incremental updates.