I'd go for the ironic approach. "Staying Alive", and "I'm still standing" are good choices, if a bit unoriginal. If I was being cremated "Burn Baby Burn" would be a good choice. For upbeat you could go with "Always look on the bright side of life". There's loads of options.
For a slightly more serious note I'd probably have someone play "Amazing Grace" on the Bagpipes like in Star Trek II.
When I die I definitely don't want a Michael Jackson style funeral, that was just creepy. I half expected them do the damn Thriller Zombies, and have some guy jump out the coffin.