If the tape will be exposed due to a transparent surface, a transparent tape can be useful to blend in. Otherwise, there’s no problem with using solid double sided tape.