SSIS SQL Server Destination Good or Bad?
The source/target databases and ssis packages are located on the same server.

Since you have above, you can use SQL Server destination. From Data loading performance guide :

The SQL Server destination is the fastest way to bulk load data from an Integration Services data flow to SQL Server. This destination supports all the bulk load options of SQL Server – except ROWS_PER_BATCH.
Be aware that this destination requires shared memory connections to SQL Server. This means that it can only be used when Integration Services is running on the same physical computer as SQL Server.

Internally, SQL Server destination uses Bulk Insert .. uses Shared Memory which is extremely fast (you can confirm running a trace to see what it is executing behind the hood).