A family tribute has been paid to “one of the most kind, thoughtful, hardworking young men” following his death in a horrific crash near Wakefield